Skip to main content
2 of 2
edited body

Instead of

=QUERY(Data1!A2:C, Data2!A2:C, Data3!A2:C "SELECT * WHERE A "&E3&" '"&F3&"'")

try

=QUERY({Data1!A2:C; Data2!A2:C; Data3!A2:C}, "SELECT * WHERE Col1 "&E3&" '"&F3&"'")

The above because QUERY doesn't allow multiple ranges but it could use an array.