Automated Student Performance Tracking Pivot Dashboard

Create a Python script using pandas and openpyxl that generates an interactive student performance dashboard from multiple school spreadsheets. The script should automatically consolidate grade data from different subject Excel files, create dynamic pivot tables showing performance trends, and generate color-coded visualizations highlighting at-risk students. Include logic to handle inconsistent data formats, missing entries, and generate executive summary reports with statistical insights.