My proposal is to write a small program that opens each file in a folder, and reads each row of each sheet, and copies the information to a new file.
I can deliver your project to you in a maximum of 48 hours.
I have more than 20 years of experience in Excel.