How to combine and display multiple ranges from different tables with an automatic formula?

Question

Google Sheets

I have several tables with ranges, 100 pieces, I want to combine them all and display them in 1 table. I know that they can be combined with {}. But manually specifying all 100 arrays in the formula is not an option, you understand.

How to make sure that the formula is not written manually, but it is generated automatically?

Here is an example: https://docs.google.com/spreadsheets/d/1zWKqaXG07X...

It indicated the tables from which ranges should be taken, next to it highlighted in yellow the formula that I wrote manually.

Answer 1

Read about Query
If you learn how to work with this formula, you will be able to solve the problem with a bang.