I have a weekly forecasting file in Excel and I need a dynamic, automated dashboard that instantly reflects any changes to employee forecasted hours. The workbook should pull the latest data as soon as it’s added (no manual refresh), then display it through clear graphs and supporting tables so managers can immediately see: • Total forecasted hours • Week-over-week change in hours • Side-by-side comparison of the current forecast against the previous version I’m comfortable if you use native Excel tools—Power Query, PivotTables, slicers, VBA, or a mix—as long as the update flow remains fully automatic and the visuals stay clean and easy to read. Deliverables I’m expecting: 1. A single Excel file containing the automated data connection, transformation logic, and the finished dashboard. 2. Documentation or quick Loom/video walkthrough explaining how the refresh works and how to extend the dashboard for future weeks. If you’ve built real-time Excel dashboards before, especially ones tracking time or capacity, I’d love to see an example and hear how you’d approach this one.