u/madbomb122

I have a query that searches multiple sheets for matches based on your input. The problem is i keep adding more sheets which means i have to update the query when i add one

Would it be possible to use a column on a sheet that lists all the sheets for the Query to look at?

My query formula
=Unique(Query({'2/13/26'!A2:A;'1/26/26'!A2:A;'12/30/25'!A2:A;'12/17/25'!A2:A;'10/27/25'!A2:A;'9/29/25'!A2:A},"Select Col1 where LOWER(Col1) CONTAINS '"&LOWER(A2)&"' Order By Col1"))
I have a Column with all those Dates in a Sheet called "Dates" where "Dates!A2:A" is the list of the Sheets to be searched

Note: If needed ill create an example sheet