You can specify, in Page Setup, what the starting page number is.
(at the bottom of the Page tab)
That would allow you to adjust the starting page number in each
workbook so the group of workbooks print with consecutive page numbers.
The free Excel add-in XL Extras will create a table of contents sheet
with each sheet name hyperlinked to the actual sheet.
Download from...
http://www.realezsites.com/bus/primitivesoftware
There is VBA code available to copy sheets from other workbooks
and place them in a central workbook if that is something you can use.
--
Jim Cone
San Francisco, USA
"Craig Perkins"
wrote in message
I am trying to create a process for my Finance department to print multiple
workbooks with page numbers that are continuous across the workbooks.
Ideally, they want to be able to create a book that has a table of contents
for each book, etc. I think this used to be possible in Office Binder, but
cannot find where this is available in Office 2003 or 2007.