Have had a good think about this one.
It doesn’t seem like there’s much consistency around what you are querying. The columns aren’t consistent and you don’t require every worksheet (which I presume can change up also)
I think it really will be quite different to come up with a solid solution here unless you have some consistency around the data inputs.
That’s really how the query editor can work best. It likes to see and do the same process over and over again without fault. As soon as new variable appear in either the data or data location this can become a bit of a problem.
Let me know if I’m missing something here, but my recommendation at the moment is to get the raw data into a better format before going to grab it with the query editor.
Personally I would work on the data usually than attempt to place bandaids over it in the query editor. If you do this then you run a big risk of a consumer looking to update the data and then getting an error and not knowing what the issue it. I’ve seem this happen too many times.
Hopefully this gives you some ideas