Drop Down menu & multiple linked cells

I have attached the document I am trying to work with. The top one is what I am trying to get to work and the bottom one is what I want it to look like when something is selected in the drop down menu. The yellow cells are drop down menues. All information is being pulled from Sheet 2.

Thanks