title: Import multiple ranges from one Google Sheet into another
body: <p>I am trying to import multiple sheets in one Google Sheet into another Google workbook. I can get <code>ImportRange</code> to work for one sheet but how do I use it for multiple sheets, or alternatively, how do I combine multiple <code>ImportSheets</code> in one column?  </p>
  
  <pre><code>=unique(
  importrange("https://docs.google.com/spreadsheets/d/...",
      "'Kramerville KH'!d5:o1000"))
  </code></pre>
  
  <p>I want to be able to add another range to that, e.g. <code>'Emalahleni KH'!d5: o1000</code>.</p>