Excel Workbook Assistance Needed -- 2

I have a set of spreadsheets that need to be turned into a clean, reliable workbook. Right now the data is scattered and the structure is inconsistent, so the first step will be a thorough clean-up: standardising headers, formats, and data types. From there, I’d like meaningful summaries—pivot tables, charts, or a small dashboard—so the information becomes actionable instead of overwhelming.

Formulas may be missing or broken; where needed, create new ones or repair existing logic so totals, averages, and lookups calculate correctly every time. Everything has to run on Microsoft Excel 365 without third-party add-ins.

Deliverables
• A single, well-organised .xlsx file with tidy data sheets and clearly named summary tabs
• All formulas functional, readable, and documented in a brief notes sheet
• Any steps you automate (e.g., Power Query) described so I can refresh the data myself

If you have a concise approach that keeps the file lightweight and user-friendly, that’s exactly what I’m after.