Hey guys -I need to print a few workbooks to scale (say 75%,) and not just a page - all the pages in each workbook. The thing is is that I need to automate ...

You can print a Selection (which will typically be one cell, unless you intentionally selected a range before opening the Print dialog), Active Sheets, or Entire Workbook.

This article explains how to create a report in Microsoft Excel using key skills like creating basic charts and tables, creating pivot tables, and printing the report.