Excel Filter/search function for large data set

Question

I currently have a dataset, the first 8 columns are unique sites (headers) filled with binary responses (Y/N) regarding the presence or absence of a species at that site. The remaining columns have information regarding different species (ie. name, diet, habitat preference, risk classification, etc).

I would like to create a drop-down box, or something similar, that will allow for the selection of a site and will display all of the data for species that are present at that site (select for the rows where "Y" is listed at that site).

Example:

Site1	Site2	Site3	Species	Diet	Habitat
Y	N	Y	A	Seeds	Grass
N	Y	Y	B	Bugs	Trees

Selecting Site1 in the dropdown box would return:

Species	Diet	Habitat
A	Seeds	Grass

Selecting Site3 would return:

Species	Diet	Habitat
A	Seeds	Grass
B	Bugs	Trees