Using lookup functions to display column and rows of multiple items from a list

I have an issue where I am trying to display information based on a dropdown list. Book1.xlsx

Per the attached file I am trying to have all the information in the red and yellow highlighted colors to display in a list fashion based upon which dropdown I select. For example if I drop down 5100 in the dropdown at the top left I want all of the information to display that is in yellow just below it. If I drop down 5200 from the list I want the all the information below 5200 to display in the exact same manner. So on and so forth. Is this possible to achieve in excel?