Welcome to the board.

If you use autofilter with Make in one column, and Model in another, you'll get exactly that behavior in the dropdowns.

See http://www.contextures.com/xlautofilter01.html