Basically I'm trying to take a physical binder of materials and convert it into a PDF document that can be updated quarterly. It's basically a binder full of cover sheets, letters, and supporting documents. I have or can get electronic versions of everything I need, that's not the problem. The problem I'm having is combing it all into a single PDF document that is easily updateable.
The cover sheets for all of the letters are contained in an Excel document with a different tab for each one (100+). The letters and whatnot are all PDFs.
I can use Excel to export to a PDF, then manually insert the documents, but the problem comes when it's time to update the cover sheets next quarter. I'd pretty much have to rebuild the thing from scratch each time, which I'm trying to avoid. Only certain things are updated, but all of the cover sheets are updated. I have Adobe Acrobat Professional 8, but I'm not very experienced with it. Is there a way I can somehow link the tabs in the spreadsheet to their respective pages in the document so they're updated, or something similar? Is there a better way to do this?
Also, is there a way to set the color of the page of a PDF? We print these cover sheets on goldenrod paper now and I would like these sheets in the PDF be the same color, if possible.