Excel Financial Data Comparison

I have three distinct sets of financial data that need to be brought together in a single Excel workbook and compared against one another. My goal is to understand where the figures diverge or align across the three sources, spot any anomalies, and surface clear insights that I can present to stakeholders without having to dig through raw rows myself. Here’s what I need from you: • Cleanly import the three data sets (I will supply them as CSV files). • Standardise date formats, currency symbols, and any category labels so each sheet speaks the same language. • Build comparison logic—formulas, PivotTables, or Power Query—showing side-by-side metrics such as totals, averages, YoY or MoM percentage changes, and variance. • Create a concise summary dashboard with charts (bar/column for variance, line for trends between sets) so I can instantly see how each data set performs relative to the others. • Make the workbook refreshable: when I paste updated data into the source sheets, all comparison views and charts should update automatically. Acceptance criteria: 1. Workbook opens without errors in Excel 2019 or later. 2. All three data sets align across common fields (dates, account codes, categories). 3. Summary dashboard updates in one click (or on file open) with no broken links. 4. Clear, commented instructions inside the workbook explaining where to paste future data and how to refresh. If you regularly work with financial modelling, variance analysis, and Excel tools like PivotTables, Power Query, and dynamic charts, this should be straightforward. I’m happy to answer questions quickly, and I’d like to see an initial layout within a couple of days so we can confirm the direction before you finalise the dashboard.