Here is my problem:

I have a Workbook with only one Worksheet within it. This Worksheet contains 6 pages. It is a "work order" type worksheet and it has a lot of data validation and locked areas to allow the user to just fill in the blanks and move on.

The issue is that the user will not always use all 6 pages. I need the user to be able to or have it automated with a macro to make only the pages that have been filled out with information to be printed, but i would like it to also print the last page "6" as it is a summary report of the worksheet. ( i.e pg 1, pg 2, pg 3 but leave out 4 and 5, and print page 6)

I hope this makes sense and thank you in advance to anyone who can help!