How to use a dropdown list to show data in 1 table with excel?

Ive created a table to show types of insurance with policy numbers and expiration dates. Is there a way to make a dropdown list of our clients that i can click on to fill the table i made? opposed to creating a table for every client..
1 answer 1