I currently hold between six and ten individual Excel workbooks, each populated with a mix of numbers and free-text fields. My goal is simple: all of this information needs to live in one clean, reliable place so that I can slice, filter, and analyse it without jumping across multiple files. Here is what the job entails from my side: I will supply every source file together with a brief note describing any column differences I already know about. Your task is to map those columns, resolve naming inconsistencies, and merge everything into a single, structured database table. Whether you prefer Power Query, VBA, or another repeatable approach is up to you, as long as the final result remains refresh-friendly—ideally I can drop new files into a folder and click once to update. Key deliverables • One consolidated Excel file (or an .accdb if Access turns out cleaner) containing all records from the original six-to-ten workbooks, with consistent headers and data types. • A short “read-me” sheet that documents the merge logic, any data cleansing steps, and how to refresh or extend the database. • No duplicate rows and no lost data; totals for key numeric fields must match the combined original sums to confirm nothing slipped through the cracks. If anything is unclear about the source files or the structure you plan to build, let me know early so we can lock it down before you dive in.