I want both tables and charts so managers can glance at trends without digging. Feel free to lean on

[Dealership KPI Report Automation](https://freelancer.com/projects/data-analysis/dealership-kpi-report-automation.html) Each month I prepare a performance snapshot for 13 dealerships plus an overall group roll-up. I now want a single Excel workbook that draws fresh data from four places—CRM exports, my boss’s Google Sheet, a marketplace XLS from our reps, and an invoice file that lists VDP views—and transforms it into a clear one-month and three-month view. The finished workbook should open on a summary sheet that shows every store on its own row, followed by a group total. For each row we need all the KPIs we already track online: Cars Online, Leads, Leads per Car, the marketplace benchmark for that ratio, VDP Views, VDP Views per Car, its benchmark, Dealership Visits, Budget and Cost...