Multiple Data Validation Database

I'm wanting to create a part lookup based on year, make, model, engine size and have it all in drop down lists. So you will select the year which will bring up the appropriate makes for that year. Then select the model based upon the year and make in the previous column. Then select the engine size based upon the model, make, year from the previous columns.

I have spent the better part of 8 hours trying to wrap my head around it but with no luck. Any help is appreciated! Thanks!

Sorry! It's been frustrating.

I have a few other tabs on this sheet that will pull data from the listing tab. I removed them from this sheet for size purposes. The Data sheet has all of the ski's we use as well as the parts. It will soon have the OEM part numbers along with it which we will use to cross reference compatible parts.

The listing tab is used for our store. I wanted to use the validation to insure that the listings are always correct and error free.

I used a pivot table but I want the drop down lists to be specific to year, make, model, and cc. So if in the year you select ex. 1994 only Makes that were made in 94 show. Then when you pick the Make only those models show, etc...

Thank you!