Merge Excel Files, Filtered Rows

I have a folder full of individual Excel workbooks and I need the relevant rows from each of them gathered into a single, brand-new .xlsx file. Each source workbook should become its own sheet in the final file, keeping its original sheet name for quick reference.

Only rows that meet specific criteria are to be copied over—I’ll share the exact rules (they’re simple, column-based conditions) once we start. Everything outside those criteria should be ignored.

Feel free to handle the task with Power Query, VBA, Python/pandas, or any other method you prefer, as long as the final deliverable opens cleanly in Excel with no external links or broken formulas.

Deliverables:
• One consolidated .xlsx file with a separate worksheet for every source file, containing only the rows that match the criteria.
• The reusable script or macro you write, clearly commented so I can tweak the criteria later if needed.
• A brief note explaining how to run the solution end-to-end.