Excel - Dynamic Table (I think?)

Hi All! I need your help.   I have a table of data of which I need to keep the format of for display and presentation purposes, but I want to have it so that when choosing a name from a drop down l...