title: Using more than one sheet for a pivot table in Google sheets
body: <p>I'm trying to link three spreadsheets in Google Sheets by using the pivot tables functionality.</p>
  
  <p>The problem that i have now is that i don't find a way to pull the data for more than one sheet. I can only operate the Pivot table with the information coming from only one.
  I have researched quite a lot, but my impression so far is that the documentation available for Google Docs is not so extensive at some point.</p>
  
  <p>Basically what i need to do is the following:</p>
  
  <p>Table 1(main):</p>
  
  <p>Car Name | ModelId | ColorID
  <br>ford |    1    |   1
  <br>fiat |    2    |   2</p>
  
  <p>Table 2:
  <br>ModelID | Name
  <br>    1    |   mustang
  <br>    2    |   bravo</p>
  
  <p>Table 3:
  <br>ColorID | Name
  <br>    1    |   Red
  <br>    2    |   Blue</p>
  
  <p>Resulting pivot table:
  <br> Car Name | Model| Color
  <br>ford |    mustang    |   Red
  <br>fiat |    bravo    |   Blue</p>
  
  <p>In SQL statements i'm basically trying to simulate a JOIN.
  I also could write a javascript script but i would like to know if there is a simple way to achieve this without coding.</p>
  
  <p>Thanks!</p>