PROBLEM:
When selecting Print Entire Workbook in excel to PDF multiple PDF files are created.
CAUSE:
Different worksheets have different Print quality resolutions.
Usually caused by Excel increasing resolution for worksheets containing images.
SOLUTION:
Change Print quality resolution in all worksheets to match highest resolution.
Page Setup > Print quality