We typically have workbooks that contain many spreadsheets, each with "Page &[Page] of &[Pages]" in the footer. Is there a way to print the entire workbook at once without the "&[Pages]" picking up the number of pages for the workbook? For example, if tab 1 is a 2-page spreadsheet, the footer should read "Page 1 of 2, Page 2 of 2" even if there are 100 pages in the entire workbook.