Mapping Data

[sparren]

I've inquired about this before, but I am still very confused.
I've attached a sample of what I'm working on below.

I have three worksheets. The first two contain the data I want to map together:

1. WWID (6 Columns):
WWID | YEAR | LITER | MAKE | MODEL | SUBMODEL

2. HOUSE (7 Columns):
HOUSE_ID | YEAR | LITER | MAKE | MODEL | SUBMODEL | Part_No

The 3rd sheet Is my Desired Sheet.
These are the columns I want:
WWID | HOUSE_ID | Part_No

So basically I want the Year, Liter, Make, Model, and Submodel columns from the first two worksheets to line up, match, and create the third.

Can anyone show me how to do this?