Any faster way to merge large Excel reports automatically?

I am working with financial and operational data in Excel and facing a recurring issue. Every day multiple reports are generated separately and each file contains thousands of rows of data.

The challenge is that I have to manually combine all these reports into a single dataset before doing any analysis or building dashboards. Even using Power Query and sorting takes a significant amount of time when the files are large.

Is there a more efficient approach to automate this process. Ideally something that can automatically pull multiple files and merge them into one structured dataset.

Has anyone dealt with something similar?
Would appreciate any suggestions or tools that could make this faster.