Excel Dashboard with Macros for PMO

I need an Excel dashboard complete with macros to effectively manage KPIs and project delivery within a PMO.

The dashboard should track the following KPIs:
- Project completion rate
- Resource utilization
- Budget variance
- Revenue and profit performance

The macros should be able to:
- Generate reports
- Send email alerts

Data visualization preferences include:
- Charts and graphs
- Tables

Ideal skills and experience:
- Advanced Excel proficiency
- Strong knowledge of Excel macros
- Experience in creating dynamic dashboards
- Familiarity with project management metrics