I have more than twenty-one separate census workbooks that need to become one clean, analysis-ready master table. All source files are in Excel, but only a portion share the same column order, header names, and data types—others drift just enough that simple copy-paste won’t work. Here is what I need from you: • Inspect every workbook, standardise field names, data types, and date formats • Append all records into one master sheet (or a single .xlsx with a clearly named “Master” tab) • Flag and resolve duplication, obvious entry errors, and encoding issues • Deliver a concise data dictionary so I can see how each original column mapped into the final table Accuracy matters more than speed; however, once the structure rules are locked, I’d like an efficient, repeatable import method (Power Query, Python pandas, or similar) so future files can drop straight in. Final hand-off: the consolidated master table, the documented transformation logic, and any helper scripts or queries you used, packaged so I can rerun the process myself if new census batches arrive.