Automation and delivery meet in a finished workbook. A macro should change the intended cells, a worksheet function should recalculate from its arguments, and print settings should preserve the reader's headings. Review each of those outcomes separately.
The first tasks use a new fictional quarterly report. Read the procedure before running it, then inspect all three output rows rather than checking only the first one. A zero refund is a valid input. The remaining tasks revisit page orientation, scaling and repeated titles on separate workbook copies. These settings affect printed pages, so a wide report may need a different orientation from its on-screen view. Use the requested settings rather than assuming one layout suits every report.