title: Importrange from multiple google spread sheets
body: <p>I know how to import data from ONE spread sheet to another:</p>
  
  <pre><code>=IMPORTRANGE(spreadsheet_key, range_string)
  </code></pre>
  
  <p>Source: <a href="https://support.google.com/docs/answer/3093340?hl=en&amp;ref_topic=3105411" rel="nofollow">https://support.google.com/docs/answer/3093340?hl=en&amp;ref_topic=3105411</a></p>
  
  <p>But how do I import MULTIPLE spread sheets into one "master spread sheet"?</p>
  
  <p>Something like this:</p>
  
  <pre><code>=IMPORTRANGE(spreadsheet_key, range_string),IMPORTRANGE(spreadsheet_key, range_string),IMPORTRANGE(spreadsheet_key, range_string)
  </code></pre>
  
  <p>All spread sheets have the exact same structure.</p>
  
  <p>I want all data in the same sheet in the same columns.</p>
  
  <p>Preferebly I would like to import all spread sheets automaticly that are placed in one folder into the "master spread sheat".</p>