How to merge tables from different files on one single excel

hello! I'm no Excel connosieur, so I'm turning to this subreddit for some help! I have 12 files on my computer (one for each month of the year 2025) who each contain between 10 to 12 Excel documents. In total, I have approximately 132 Excel books that I need to merge into one single Excel.

All of these Excel files have the same table format, except for maybe 5 that contain the same information as the rest. The rows, instead of being in the same order as the others, are mixed up.

I've tried using Power Query, but half of the Excel files I import come up empty/only bring half of the information.

Does anyone have any recommendations/YouTube video tutorials, or some tips/tricks to tackle this as quickly as possible? I'm sure anything is faster than just copying and pasting everything manually.

Thank you for reading!!