I prepare monthly reports for my company's executive which are 60-65 printed pages from about 20 Excel workbooks. At present, I print off all of the workbooks, collate them into sets, then run each set through the printer a second time to print page numbers from a Word template set up specifically for the purpose.

Does anyone know of a tool which will enable me to select a set of workbooks, send them to the printer, and have the page numbers print automatically?

Any pointers will be appreciated.

Trish