I have a set of rows. From row A, I have a dropdown menu. Source of dropdown menu is from sheet 1.

When I select an item from this dropdown menu, I would like excel to search for that item in sheet 1 and list all the items listed under that heading.

Any idea how to do this please?