title: Filter function for multiple sheets
body: <p>I am trying to filter data from multiple sheets using the newly introduced FILTER function. I have saved a named range for sheet names to use as an Array.
  This is the formula I am trying to yse but it gives me #Value error. But it works if I use for a single sheet. aharu is the namedrange array for Sheet Names.</p>
  <pre><code>=FILTER(INDIRECT(&quot;'&quot;&amp;aharu&amp;&quot;'!$B$2:$B$1200&quot;),(INDIRECT(&quot;'&quot;&amp;aharu&amp;&quot;'!$L$2:$L$1200&quot;)=&quot;&quot;)*(INDIRECT(&quot;'&quot;&amp;aharu&amp;&quot;'!$J$2:$J$1200&quot;)&lt;=EDATE(TODAY(),-6)),&quot;No data&quot;)
  </code></pre>
  <p>How to use filter function for multiple sheets?</p>