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!