Trying to pull data from cell based on criteria in another cell, while skipping blank cell

I am working on a sheet involving various placement data. I want to have individual sheets for each class which includes only the students who place into that class and ignores students who do not place into that class; however, my Excel knowledge does not go far beyond IF or INDEX and MATCH. I cannot figure out how to use a formula to skip cells/rows that do not meet the criteria.

Sample sheet is attached.

(EDIT: attachment wasn't working so here is link to sheet uploaded to Drive)
https://drive.google.com/file/d/0B4q...ew?usp=sharing

The Overview sheet houses all placement data. On ENG 121 I want to only pull names that have "Yes" under ENG 121 on the overview sheet. The closest I know how to get is an IF function, but that returns 0 for kids w/o Yes. I need it to skip them.

Duplicate thread closed.