Auto-populate cells based on value in dropdown list

Good afternoon. I have two sheets in my workbook that I am using to do a vehicle cost analysis for a fleet of school vehicles. Sheet 1 is the actual cost analysis sheet while sheet 2 is a list of vehicles. On sheet 2, the vehicles are placed into a category based on its age. I want to choose a category from the dropdown list on page 1 and auto-populate the list of vehicles based on the category on page 2. Can this be done? Thanks for the help.