Creating drop down menus with extensive changing content

Hello all,

I have a problem (I have intermediate knowledge of Excel): lets say that I have two model years for Cadillac: 2013 and 2014, and have 3 car models for year 2013 (ATS, XTS, and CRX) and two car models for year 2014 (ELR and CTS Sedan). I want to create a dropdown menu under "Model Year" that will show me 2013 and 2014. When I click on either one, a dropdown list for all car models for that year can appear in the next column under "Models". Then, for each car model, there are different characteristics that are in other columns, such as horsepower, mileage, etc...I want all of the content to stay on one line (row), but change when I click on a different model. Can this be done? Thank you so much in advance.

Thank you for the link, the only thing is that I don't want the other columns, which include characteristics such as horsepower and mileage to be dropdown menus too. the only menus are the model years and models, the rest is content that will change when a model is selected.