Macro for connecting tables to PowerQuery

I have a workbook with ~1000 sheets, each sheet contains a table with different column headers. A lot of the headers are the same/repeat but there are some tables with unique columns. I am trying to append the tables so that the data is consolidated while also accounting for any unique columns. I was thinking to use PowerQuery to do this but connecting each table will take far too long.

Does any one know of an easier way to approach this? Is it possible to create a macro that would connect each table to PowerQuery? I'm very new to VBA so I would need some assistance with the macro option :/