Return Specified Values From Another Sheet

I have two Excel sheets open. The first sheet has data organized by Student ID and by School (two different column). In the second Excel sheet, I simply want to return a column that shows the Student ID of all students belonging to a specified school. How do I do this dynamically? If I change the specified school, then presumptively my Student ID list too should change. Thanks in advance - I'm a newbie here!

Insert a PivotTable of your data. Add "School" field to filters area, and "Student ID" to rows area. Don't add any values. Hey presto, a list of students filtered by school.

Instead of using a filter, consider adding a slicer for the Pivot Table for a more end-user self-service look and feel. No good if list of schools is really long though.