Hi I am using excel 2000

I have the following code for printing each Area Managers Individual store reports

Please Login or Register  to view this content.
Each Individual store report prints out on 4 sheets of paper, how can the above code be changed so that the sheets print in reverse order

It will save me having to collate it all by hand, there are 78 stores x 4 sheets