I need to turn an existing workbook into a smart, self-updating tool that does two things for me: • Automated data entry – the moment a new CSV lands in my folder, the sheet should import the data, clean it, slot it into the right table, and validate key fields without manual clicks. • Trend analysis – once the data is in, the file must crunch month-over-month trends, calculate 3-, 6-, and 12-period moving averages, flag anomalies, and refresh charts plus a short written insight summary. Feel free to use VBA, Power Query, Python, Office Scripts, or a mix that stays compatible with Excel 365. The end deliverables are the working workbook, any supporting scripts or add-ins, and concise setup notes. I’m aiming to wrap this within the next month, so let me know your approach and any dashboards you’ve built that show similar AI-driven automation.