How to reference another sheet in the QUERY function?
<p>In short, this doesn't work:</p>

<pre><code>=QUERY(SHEET1!A:E, "where 'SHEET1'!B contains '"&amp;A1&amp;"'")
</code></pre>

<p>I am shown:</p>

<blockquote>
  <p>unable to parse query string</p>
</blockquote>

<p>and I can't work out why.</p>