Printing a subset of page numbers in header, while total pages in footer.

Hi,

I am trying to print an entire workbook that contains 30 pages spread across 20 tabs (schedules for a report). In the footer of each sheet I have "Page &[Page] of &[Pages]" which gives me from Page 1 of 30 to Page 30 of 30. A few schedules are more than one page however, and on these I want the header to say "Page 1 of 4", etc, if there are 4 pages on that schedule. How can I do this subset of pages within a full workbook of pages?

Please help.
Thank you!
Dan