I'm struggling with an "optimisation" issue and hope someone could have a genius hint ;-)

Context

I have a bunch of sheets which contains "compatible but heterogeneous" data => each sheet contain same type of data but structured different ways.

• Each sheet has its own useful range which is defined by a named range.
• Each sheet has 2 variable columns and a static column which roughly depends on the sheet name.
• The number of queries is quite significant
• For the moment, I am making a literal table that contains all the parameterised queries in a comprehensive manner. Which gives the following:
  • This is resulting in an ugly endless formula
  • If anyone wants to add, modify or remove a query, then he has to grapple with this unbearable formula.

Goal

My goal is to produce a table in another sheet which aggregate all data from all sheets described in "Context" Hence I set up a "parameters" sheet in which I define all queries to run, listing all named ranges and corresponding query to do on this range.

• Each query is set up to run with INDIRECT mechanism
• The list of queries is set to be extensible as needed
• Each query has its IFERROR to produce an empty row in case of N/A, to avoid errors.

Issue

I can build and run any query without any problem, but can't sort stacking output all queries of the configuration table

Here is a sandbox workbook which describes my issue

Hope all is clear with this description.

Any thought on this?

Thanks to community!

Emmanuel

You can stack the results of multiple queries using REDUCE

=LET(
   ranges; A4:A5;
   queries; I4:I5;
   REDUCE(
     TOCOL(;1);
     SEQUENCE(ROWS(ranges));
     LAMBDA(result; i; VSTACK(
       result;
       QUERY(INDIRECT(INDEX(ranges; i)); INDEX(queries; i))
     ))
   )
 )