Excel File Consolidation & Summary

I have a folder of Excel workbooks that all share the exact same column order and formatting. I need every row from every file pulled into one clean, master worksheet. Alongside that master sheet, I’d like a lightweight summary that simply shows the total number of rows combined and a few key totals pulled from the relevant numeric columns.

Accuracy is critical—no duplicates, no missing rows, and column integrity must be preserved. Feel free to automate the process with Power Query, VBA, a Python script, or any other reliable approach you prefer, but please return the finished .xlsx file ready for immediate use.

Deliverables
• “Master” sheet containing all rows from every source file
• “Summary” sheet reporting overall row count and key totals

If you provide a reusable macro or script, include brief usage notes so I can refresh the file set in the future.