Myntra Excel-to-CSV VBA Automation

I maintain large Excel files exported from Myntra and need them transformed into clean, ready-to-upload CSVs at the click of a button. The work is strictly re-organising: reshuffle columns into a fixed layout, normalise headers, drop unused rows, and save each sheet (or a consolidated range, if easier) as a separate CSV file.

I will provide a sample workbook that shows exactly how the raw data arrives and a template that illustrates the desired CSV structure. Your job is to write a well-commented VBA macro housed in the same workbook so I can press a single control and generate the files automatically whenever new data comes in. No external add-ins are permitted; standard VBA in Office 365 is fine.

Deliverables
• The macro-enabled workbook (.xlsm) containing all code
• Clearly commented VBA so I can tweak column names or paths later
• One example run that produces the target CSV, proving the layout matches the template

Acceptance criteria
• Column order, naming and data formats replicate the template exactly
• Macro runs without errors on variable row counts
• Output CSVs save to a user-defined folder each time

If you have already automated similar data flows in Excel using VBA, let me know; a short demo or code snippet would help me choose quickly.