Excel Comments Consolidation by Category

I have one Excel workbook that already holds several sheets of raw comment data. What I need is a clean, automated way to re-organise everything so the final file still contains multiple sheets, but now each sheet represents a distinct comment category rather than the current scattered layout.

Here’s the flow I’m after: pull the comments from every existing sheet in the source workbook, detect the category field in each row, and then funnel those rows into brand-new sheets named after each category. If a category doesn’t yet exist, the routine should create the sheet on the fly; if it does, just append the new rows without overwriting prior data.

A lightweight VBA macro, Power Query routine, or simple Python script that I can re-run whenever fresh comment dumps arrive would be ideal—as long as the end result is an updated workbook ready to open in Excel with clearly separated category sheets.

Deliverable
• A reusable solution (macro, query, or script) plus the first combined workbook so I can verify the layout.

Please keep formulas or code readable and add a brief note explaining how to refresh the process next time.