Pull Data Depending on Multiple VINs and Multiple Makes from cells

So, I have the Attached Spread Sheet and what I'm wanting is to be able to insert the VIN number into it and depending on what Make it pulls up pull the Following Information from my Data Sheet

lets say I enter a VIN and it say's Chevrolet I want it to pull the Model, Engine, Chassis, and GVRW info from my Data Sheet.

However, If I enter a VIN and the Make is Ford then it will pull my Model, Engine, Chassis, and GVRW info from my Data sheet for that info as well.

Is there a Formula that can do this?

I'm really at a loss at this point, I've even though about taking some portion of the makes and adding it onto the VIN breakdown part to search for everything. The problem with this is that each manufacturer searches for the codes Differently.

Any help is greatly appreciated.

Thank you.

The sample workbook shows empty results tables - you need to manually populate 10-15 lines of data in each to show what you are trying to achieve.

Sorry about that,

Here is an updated File with some Sample VIN numbers in the Front Sheet A2:A10

These Vin's Feed into my Data sheet and then gets broken down.

What i'm wanting to happen is the vin gets read and fed into Data then it will read the model and populate the Front Sheets Model, Engine, Chassis, and GVRW Columns.

One way I thought about doing this is to make all my Columns in Data Sheet to - blank if the Make Doesn't Match.

Like if the Truck ends up being Peterbilt then all the other cells that aren't pulling from my Peterbilt Sheet would return blank.

Then on my Front Sheet I could add up all the Model Codes and only the Peterbilt Model would Show up. (My Peterbilt Columns are the ones labeled Model - p, Chassis - P, Engine - P, and GVRW - P.

I hope this makes Sense to you and I'm not being too confusing trying to explain it all.