title: Combine first column of n sheets to one colume
body: <p>So in one spreadsheet file we have n sheets.</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">Sheet1</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">Names</td>
  </tr>
  <tr>
  <td style="text-align: center;">a</td>
  </tr>
  <tr>
  <td style="text-align: center;">b</td>
  </tr>
  </tbody>
  </table>
  </div><div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">Sheet2</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">Names</td>
  </tr>
  <tr>
  <td style="text-align: center;">b</td>
  </tr>
  <tr>
  <td style="text-align: center;">c</td>
  </tr>
  <tr>
  <td style="text-align: center;">d</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>and so on.. assume n sheets with n values in the first column</p>
  <p>Then there's one super sheet.
  Super sheet</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th style="text-align: center;">Supersheet</th>
  <th style="text-align: center;">Supersheet</th>
  <th style="text-align: center;">Supersheet</th>
  <th style="text-align: center;">Supersheet</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td style="text-align: center;">Sheet1</td>
  <td style="text-align: center;">Sheet2</td>
  <td style="text-align: center;">Sheet3</td>
  <td style="text-align: center;">...</td>
  </tr>
  <tr>
  <td style="text-align: center;">Names</td>
  <td style="text-align: center;">Count</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;"></td>
  </tr>
  <tr>
  <td style="text-align: center;">a</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;"></td>
  </tr>
  <tr>
  <td style="text-align: center;">b</td>
  <td style="text-align: center;">2</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;"></td>
  </tr>
  <tr>
  <td style="text-align: center;">c</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;"></td>
  </tr>
  <tr>
  <td style="text-align: center;">d</td>
  <td style="text-align: center;">1</td>
  <td style="text-align: center;"></td>
  <td style="text-align: center;"></td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Assume A1:1 is a list of all of the names of the sheets we want to fetch names from. We want the names pasted into A3:A.</p>
  <p>My first thought was to do
  <code>=unique(filter({INDIRECT(A1&amp;&quot;!A3:A&quot;);INDIRECT(B1&amp;&quot;!A3:A&quot;);INDIRECT(C1&amp;&quot;!A3:A&quot;)},{INDIRECT(A1&amp;&quot;!A3:A&quot;);INDIRECT(B1&amp;&quot;!A3:A&quot;);INDIRECT(C1&amp;&quot;!A3:A&quot;)}&lt;&gt;&quot;&quot;))</code>
  and expand, but that doesn't take care of N sheets.</p>
  <p>So what I thought I could do was
  <code>=ARRAYFORMULA(INDIRECT(A2:C2&amp;&quot;!A2:A3&quot;))</code>
  but that only takes care of sheet1. INDIRECT doesn't work with arrayformula</p>
  <p>So what can I do?</p>