title: Use query to combine data from ever-changing tab list
body: <p>I am building a Sheet that will be taking imported data from other tabs and combining it in a summary sheet, for me to use elsewhere. The problem is, the tabs will be imported monthly, so there will be dozens of them very quickly, and I don't want to edit the query function every month. They will all have the same naming format, but I'm wondering if anyone has an idea about how to formulate the query with variables for the sheet name that I can pull from another cell. For example, I could import the tab names into another row, and have the query pull the sheet names from that row, but I am not familiar with how to do this. Here is an example of the query formula I'm using in a similar sheet:</p>
  
  <pre><code>=QUERY({'2019 TEAM SALES'!A2:ZY; '2020 TEAM SALES'!A2:ZY}, "select * Where Col1 is not null",1)
  </code></pre>
  
  <p>With this one, updated once a year isn't a big deal. But this new sheet will be monthly, so it will be unwieldy in just a few months. Is there a way using query to take the sheet names via cell info? Like if in row 1, I concatanate the sheet names with the range, so that A1 contains "'2019 TEAM SALES'!A2:ZY" and the next in B1 and so on, and then the query formula is:</p>
  
  <pre><code>=QUERY(A1:ZZ1, "select * Where Col1 is not null",1)
  </code></pre>
  
  <p>This way, it will always pull in all the current tabs necessary to combine.
  Incidentally, I'm open to using other formulas or even a script to get this done, as it's the result I'm after, not the method.</p>
  
  <p>I have seen a lot of answers similar to what's <a href="https://stackoverflow.com/questions/57549012/is-there-a-dynamic-way-of-accessing-ranges-from-multiple-tabs">here</a>, but this still forces extremely long formulas that I don't think are very efficient, given that this sheet will eventually have 50 or more tabs in it.
  Thanks for any insights!</p>