I have a workbook that has 3 sheets per company and there are 10 companies. For example sheets 1,2,&3 are the 3 reports for company 1. Sheets 4,5,&6 are reports for company 2, and so forth. I want to create a macro that will group the reports according to company and print to pdf. I've searched and searched but haven't found the solution to my problem.