Merge and filter data from multiple google sheets tabs
<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>