Automated Excel Dashboard

I have three-to-four separate Excel workbooks (about 100 MB total) that track related data streams. I need a single, clean Excel dashboard that automatically pulls, merges and refreshes those numbers whenever the source files are updated.

Here’s what I’m expecting:
• One master .xlsx file that uses native Excel tools—Power Query, PivotTables, slicers or any technique you find best—to connect to each source workbook, consolidate the data and present it in a set of well-designed charts, tables and KPIs.
• All links set up so that a simple Refresh brings in new data without breaking formulas, formats or visuals.
• Clear, in-file notes (or a short PDF guide) explaining where the connections live and how to add or remove a source file in the future.
• Performance tuned for a 100 MB data load so the dashboard opens and recalculates quickly on a standard office laptop.

When you respond, please attach examples of past work that show similar Excel automation or dashboard projects; that will help me gauge fit quickly. I’ll be available to clarify field definitions, naming conventions or any other details you need once we start.