Help Compiling Lists

I'm a school administrator tracking attendance across multiple campuses.  Each campus is on one worksheet.  I have drop down lists indicating if someone is present, or the type of absence, and it's separated by date. 

What I would like is:  compile all the instances in the workbook that someone was ill or on vacation, and then on a separate worksheet, list all the corresponding student's name and campus location for that day.  

Info you may need:  Worksheet Name is the same as the Header, there are about 12 sheets, I'm a new excel user, so please keep that in mind when you're explaining what is probably a very simple formula 🙂 

If anyone can provide me with a generic formula that you can dumb down for me, I can probably plug in the right info.