Filtering Table from a drop-down list

[qetuo]

Here's my situation:

I have an 100-member staff list table with individual columns for Name, Title, Office, etc.. These staff are categorized by which group(s) they are involved with. I have created a drop-down list with each individual group as possible selections.

Problem:

How do I use excel to filter the staff list so that when a user selects any given group from the drop-down list, only the members (and their information. e.g. Title, Office, etc..) from the master list who are in that selected group remain visable to the user.

I've though about using a seperate sheet, and using multiple IF statements, but I have the feeling there is a better way to do this. Any feedback would be appreciated.

Thanks

[khamilton]

Here is a small sample.

filtering from drop down.xlsx