title: Merge and filter data from multiple google sheets tabs
body: <p>I have 3 google sheets tabs, all with the same columns and would like to add a 4th tab that displays all of the data from the other 3 tabs where column K = "Q116".</p>
  
  <p>Importing all of the data from the 3 sheets is easily achieved:
  =query({'Sheet 1'!A3:Q50;'Sheet 2'!A3:Q50;'Sheet 3'!A3:Q50})</p>
  
  <p>However, I can't work out how to add a filter/where clause to only return results where column K (in all sheets) = 'Q116'.</p>
  
  <p>Any ideas?</p>
  
  <p>Thanks!</p>