By adding the PDFCreator reference to VBA, you can merge any number of PDFs. Create a sub to save the sheets as PDF, then modify the code above to merge them.