I want to replace a string of repetitive clicks and copy-pastes with a single AI-driven workflow inside Excel. The goal is simple: as soon as I drop a raw file into the workbook, everything else happens on its own—no manual intervention, no formula tinkering. The automation must cover: • Data entry: pull new files or pasted tables into the correct sheets and date-stamp them. • Data cleaning: trim spaces, unify formats, remove duplicates, and standardise headers automatically. • Formula calculations: run the existing logic (or an improved equivalent) and output ready-to-use results. I’m flexible on how you implement this—VBA macros, Office Scripts, Power Query, or a Python bridge such as xlwings are all fine as long as they stay within an Excel-centric workflow and are easy for a non-coder to run. Deliverables 1. The working automated workbook (or add-in/script) with all code unlocked for future edits. 2. Clear, step-by-step usage notes so anyone in the team can refresh the data without your help. 3. A short change log explaining key functions and where to tweak them if business rules evolve. Everything needs to be tested on the latest Microsoft 365 desktop version; compatibility with older .xlsm files is a bonus but not essential.