excel vba coder needed - part -2

I have an existing workbook filled with daily, click-heavy routines that I’d like to collapse into a single, reliable macro. The goal is straightforward: eliminate the manual steps and let Excel handle them automatically, end to end.

What I need from you
• Clean, well-commented VBA code placed inside the workbook (no external add-ins).
• A clear explanation—either inline comments or a short note sheet—so I can adjust ranges, sheet names, or file paths later on.
• A quick demo run (screenshare or recorded clip) proving the automation works on a fresh copy of the file.

Acceptance criteria
• All steps now execute with one action (button or workbook-open event).
• No hard-coded references that break if I change row counts or add sheets.
• Macro runs smoothly on a standard Windows install of modern Excel (2016 and above).

If you have questions about any specific step in the process, let me know early so we can pin it down together.