I still don't understand
answer for this:
1. how many rows you have for each file
2. do you want display the result in the Excel sheet (limited) or in Power Query (not limited)
3. you can load many files into Power Query but you can append queries in Power Query and see unlimited result or load result query table into the sheet with limitation as I said above