Python Excel Automation Script

Every month I have to pour fresh sales data into multiple Excel workbooks, clean it up, run a few analytical routines, then move the output into summary sheets for management. I’d like all of that to happen at the press of a button, so I’m looking for a Python-based solution that automates both the data-entry phase and the analysis that follows.

Here is what I need:
• A Python script (pandas, openpyxl or similar) that ingests new sales files, appends them to my master workbook, and performs the recurring calculations I currently run by hand.
• Clear, well-commented code plus a short read-me so I can adjust source and destination paths in the future.
• A quick screen-share hand-off session to confirm the script processes a sample month correctly and that totals match my existing manual output.

The workflow is strictly monthly, so performance can be tuned for one large run rather than daily streaming. If you have ideas for extra validations or a lightweight dashboard, feel free to suggest them—I’m open as long as the core automation is rock-solid.