Hi, its a bit hard to explain but here goes.

When you setup pages and add [page] of [pages], pressing print or print preview will display in the footer page 1 of ??, page 2 of ?? etc etc.
I don't want it to say page 1 of ?? then page 2 of ?? etc, I want to be able to print the selected sheets with a starting page number of my choice.

Even though I may select 20 worksheets ( normally print 1 of 20 etc ), I want it to select the starting number then have the sheets count up from the ?? to the last page.

I have 5 workbooks, each with 20 worksheets ( each sheet being 1 x A4 page ) and need to produce a document 100 pages long but need 20 pages from each of the 5 files.

I set the last page to 100 then print sheets 1 to 20 from each file, the 1st file I enter 1 to 100 ( 20 pages ), 2nd file I enter 21 to 100 ( 20 pages ), 3rd file 41 to 100 etc till
I have 5 pdf files each having 20 sheets in them, at that point I merge all 5 pdf's to produce 1 massive 100 page document.

This way I can produce 1 document from 5 workbooks 100 pages long and its seamless.

Hope this makes sense.