Excel Progress Tracker Automation

I need a single, rock-solid Excel solution that pulls live data from roughly 45–50 existing worksheets and rolls it into three summary blocks on each sheet: TASKS INITIATED, TASKS TRAINED, and % TRAINING COMPLETED. The sheets vary in length, but they all track skill assessment tasks that move from RED to YELLOW status once an “X” is entered—those formulas are already in place.

What I do not have is an automated way to:

• Total the results across every worksheet
• Divide the final “% Training Completed” figure by two so the dashboard always shows half of the gross percentage
• Present progress as clear percentages (no bar charts or color scales)
• Trigger an email notification the moment any student hits a predefined threshold I can edit later

I’m comfortable running a macro, enabling VBA, or using Power Query—whatever gets the job done quickly and remains easy for me to maintain. Turnaround is critical: I need a working file ready to test within 24 hours of award.

Deliverables
1. Updated workbook (or add-in) that auto-aggregates data from all 45–50 sheets and updates in real time or on workbook open
2. Formula or VBA routine that halves the final “% Training Completed” figure before display
3. Email alert functionality configurable for threshold values
4. Brief hand-off notes so I can adjust sheet counts or thresholds without rewriting code

If you’re confident you can wire this up fast and accurately, I’d like to hear from you right away.