Automated Excel Sales Dashboard

I’m looking to turn a stream of raw sales data into a polished, self-updating Excel dashboard. The job is firmly about dashboard creation: automate the way the data is imported, cleaned, and visualised so that with a single refresh my team can instantly see revenue, units sold, and regional performance without touching formulas.

Here’s what I need the workbook to do:
• Pull new sales files in automatically (Power Query, VBA, or another reliable method is fine)
• Update pivot tables, charts, and slicers dynamically so row counts can grow or shrink without breaking anything
• Present the key KPIs in an intuitive layout that non-technical colleagues can navigate
• Recalculate quickly and keep file size reasonable

Deliverables
• One ready-to-use .xlsx containing the automated sales dashboard
• Short setup notes explaining how to point the model at future data sources

If you have past examples of Excel-based sales dashboards—especially those built with Power Query, VBA, or dynamic arrays—feel free to include a screenshot or a lightweight sample so I can see your style.