Word & Excel Macro Automation

I need to replace a handful of repetitive steps in both Excel and Word with clean, reliable VBA macros. In Excel the routine involves importing raw CSV files, re-formatting them, and generating summary pivot tables. In Word I’d like a macro that pulls those finished tables into a report template, updates reference fields, and exports the final document as PDF—all triggered by one or two buttons.

If you’re comfortable writing and debugging VBA in both applications, this job should be straightforward. Please build the code in a way that is easy for me to maintain: use clear variable names, add short inline comments, and keep everything in one macro-enabled workbook (.xlsm) and one macro-enabled document (.docm).

Acceptance criteria
• Excel macro processes a sample CSV without errors and produces the expected pivot output.
• Word macro imports the latest pivot tables, refreshes cross-references, and saves a PDF into a designated folder.
• All macros run on Office 2019 and Microsoft 365 for Windows without additional add-ins.

I’ll supply sample data, the report template, and quick feedback as you progress; just let me know what you need from my side.