Matching 2 cells and picking value from a 3rd cell that is based on repeated text field

I need to match Model and week in both source and destination tabs and then pull in the "WM Total" for that week into the destination tab for each model. I would really apprecicate the help.
Here is an example. Thanks.