Commission Tracking Workbook Automation

I need an Excel workbook, driven by solid VBA, that removes the manual work from my commission process. The file will track commissions across several sheets and automatically move or refresh data whenever the relevant outcome or status is selected on the input sheet. As those changes occur, the workbook should:

• Instantly update linked tables and ranges in the downstream sheets according to criteria I will specify.
• Roll up the latest numbers into clear, ready-to-print reports that pull figures from multiple sheets—no extra clicks or copy-paste.

The core focus is automation, so the macros need to be reliable, well-commented, and easy for me to tweak later (new reps, new products, new percentage tiers, etc.). I’ll share the existing template and the exact business rules once we start; your job is to wire it all together, add any helper sheets you think improve stability, and return a turnkey workbook that runs with standard Excel—no external add-ins required.

Deliverables
1. Final .xlsm file with protected but unlocked VBA modules.
2. Brief setup guide explaining sheet flow, key procedures, and the points where I can edit criteria or rates.
3. A quick demo (screen share or short video) proving the automated updates and report generation work as intended.

If you’ve built similar multi-sheet, criteria-driven workbooks, I’d love to see an example. Let’s streamline this commission cycle.