How to create a formula that will change dynamically in Google Spreadsheets?

Question

Google Sheets

Hello,
There is a table to sort brands by category and date. You need to make a `Query` function with dynamic ranges that will change depending on the presence of data in them.
Essentially, I need to insert data from the cell ` Workshop!I2 ` into `All Query!A1 `, not as data, but as a function.
For example, in `Workshop!I2` `Query({'Query 1'!A1:H;'Query 1'!I1:P;'Query 1'!Q1:X;'Query 1'!Y1:AF;'Query 1'!AG1:AN;'Query 1'!AO1:AV;'Query 1'!AW1:BD};"Select * Where Col1 !=''")` then in `All Query!A1` it should work.
Since there are several ranges, indirect does not help

Answer 1

And if indirect-y submit parameters as a result of the corresponding functions?