I have a workbook with multipile tabs. From this workbook, I create reports for numerous individuals, each report using a diffent combination of said tabs.

The printer I use has the ability to collate and staple. For instance, when I print a multiple copies of the same PPT presentation, I can have the printer collate, and staple each packet. I would like to be able to do this with Excel.

How can I use VBA to define a certain combination of tabs as a "group" so that the printer sees it as one print job and staples it?

I hope I am being clear in what I am trying to do. If not, let me know and I will try to explain better.

Thanks.