Indexing matching and dropdown boxes

Hi, im trying to create a excel that uses the previous cells dropdown box option as a reference. Then takes that data and searches another sheet for options listed below it and repeates several times referncing the cell before. Not sure if ive explained it well. Ive provided a doc. Sheet 1 is like an entry area where people enter data based on dropdown boxes that use data from sheet 2.

I want it to search specified rows from sheet 2 (sometimes several rows, ex. search Row 12 and Row 17 from sheet two for the key term chosen from the sheet 1s selection, then list the options below it from sheet 2 in a dropdown in sheet one