Using more than one sheet for a pivot table in google sheet

I am trying to link three tables in Google Sheets using pivot table functionality.

Now the problem is that I can't find a way to pull data for multiple sheets. I can only use a pivot table with information coming from just one. I've researched quite a bit, but so far I can see that the documentation available for Google Docs isn't that extensive at some point.

Basically, I need to do the following:

Table 1 (main):

Vehicle name | ModelId | ColorID
ford | 1 | 1
fiat | 2 | 2

Table 2:
ModelID | name
1 | mustang
2 | Bravo

Table 3:
ColorID | name
1 | red
2 | Blue

Resulting pivot table:
Vehicle name | Model | color
ford | mustang | red
fiat | bravo | Blue

In SQL statements, I am mainly trying to mimic JOIN. I can also write a javascript script, but I would like to know if there is an easy way to achieve this without coding.

Thank!