Macro for same filter, multiple sheets

[schwincat05]

All-

I am a VERY new excel user. I am trying to create a filter which takes data from (Participant Master Tracker, Sheet1) and filters the data in Column B (Class Location) to a specific worksheet. I have all of the worksheets listed, but there are 100+ and I would like to have a not have to go through each page individually to link and filter each one. Is there any way to do this automatically?


The file is attached.

Thanks in advance.