I have an issue that is less complex and I was wondering if there was any suggestions.

I have multiple worksheet objects that I have named. Currently my print macro looks like this

Inputs.PrintOut Copies:=1
Income.PrintOut Copies:=1

I have a central footer on each one of these pages that has the page number of pages (1 of 2, etc.). The issue is that the code I have written prints out each object individually and then moves on to the next one, so the footer of Inputs says 1 of 2, then the footer of Income says 1 of 2, etc. What I want to have happen is print them all at once, and have the footer say 1 of 4 on the 1st page of inputs, and 3 of 4 on the 1st page of Income.

Any thoughts?