Merge via 10-30 Excel Sheets Taskk Open

I have between ten and fifty Excel workbooks, all laid out with identical columns and formats. I now need every record merged into a single, clean spreadsheet that I can use as a lightweight database for reporting and analysis.

Once delivered I’ll test a few random samples and confirm row counts match the originals before sign-off.
Attention to details beloww

The data needs to be analyst with potentially creating a PowerBI Dashboard for quick data insights...Attention to details beloww