Excel 2010: Need Pagination Continous Across Worksheets for Regular Viewing, Not Just Printing

[pdevito3]

Hi,

So I have a workbook with about 20 worksheets. They have headers and footers and I am using pagination for each of the sheets. If I select all of the sheets and print I know that Excel will order the sheets across the workbook continuously and that is great, but I need Excel to do this in the workbook itself too as I am viewing it.

So, If I have
Sheet 1 with 1 page
Sheet 2 with 2 pages
... Sheet 20 with 4 pages
40 pages overall

I need to be able to look at the sheets without being in print preview and see sheet one say page 1 of 40, sheet 2 say page 2 of 40 and page 3 of 40, etc.

Any advise?

Thanks