Excel VBA Pivot Report Automation

I want a single-click VBA routine that takes raw data already sitting in one worksheet, refreshes it, and then builds a cleanly formatted PivotTable report on a separate sheet. The goal is to stop the manual copy-paste cycle and have the file produce the same pivot each time—with correct filters, number formats, and a time-stamped tab name—whenever I run the macro.

Key points
• Purpose: fully automate report generation; no other tasks are in scope.
• Report style: PivotTable only (no summary or detailed row-by-row exports).
• Typical flow I envision: import/refresh data → create or refresh PivotTable → apply layout & formatting → save workbook. If you can also include an optional step that exports the finished pivot to PDF, great, but it isn’t mandatory.

Deliverables
1. A macro-enabled workbook (.xlsm) containing well-commented VBA code.
2. Brief usage notes so anyone on my team can press the button and reproduce the report.
3. Clear indication in the code where I can change data ranges, field order, or formatting later.

Acceptance criteria
• Running one procedure produces an up-to-date PivotTable without manual intervention.
• No hard-coded file paths—everything should work inside the workbook.
• Code is readable, logically structured, and error-handled (e.g., if the data range is empty).

If you have questions about field choices or layout options, let me know up front so we lock those in before you start coding.