Formula to retrieve data from several sheets and return values from given criteria.

I am trying to get data from each of our areas of the school staff timetables EY  MY  LY and summaries what days each staff member works where to another sheet, as staff move around.   I would apprec...