Is there a way of combining files automatically into pdfs according to excel data storing recipes for the file combinations?

Report · Mar 08, 2016

I would like to be able to merge and/or print different combinations of files together according to specifications which are stored in an Excel spreadsheet(Recipe Sheet) which itself references another sheet(Tag Sheet) that acts to store filenames according to tags, and create print ready PDF files.

Example:

Recipe Sheet

Row/Col.....................A.......................B............C............D............E............F...........G........

1............./filename1.pdf.../filename2.pdf..........................5...........3...........................1.........

2............./filename3.pdf.../filename1.pdf............2............2...........2..............1......................

3............./filename1.pdf.../filename2.pdf............2.........................2..............1......................

4............./filename1.pdf.../filename3.pdf...........................1...........2.....................................

5............./filename1.pdf.../filename2.pdf............4.............2...........2...........................1........

etc.

Where in Columns C--G(Subject to Change) 1,2,3,etc. stand as tags for other files which are stored in another excel sheet

Tag Sheet

Row/Col................................A...

1............./taggedfilename1.pdf...

2............./taggedfilename2.pdf....

3............./taggedfilename3.pdf...

4............./taggedfilename4.pdf...

5............./taggedfilename5.pdf...

etc.

And output should be (and optionally printed out in order.)

pdf1 : filename1.pdf + filename2.pdf + taggedfilename5.pdf + taggedfilename3.pdf + taggedfilename1.pdf

pdf2 : filename3.pdf + filename1.pdf + taggedfilename2.pdf + taggedfilename2.pdf + taggedfilename2.pdf + taggedfilename1.pdf

pdf3 : filename1.pdf + filename2.pdf + taggedfilename2.pdf + taggedfilename2.pdf + taggedfilename1.pdf

pdf4 : filename1.pdf + filename3.pdf + taggedfilename1.pdf + taggedfilename2.pdf

pdf5 : filename1.pdf + filename2.pdf + taggedfilename4.pdf + taggedfilename2.pdf + taggedfilename2.pdf + taggedfilename1.pdf

etc.

Thank you for any suggested solutions.