Creating an Excel timetable

I have created course timetables for groups of students. i.e. a timetable on a sheet for each day, with the students' names across the top. What I would like to do now is to combine the five days into a weekly timetable for each student. i.e search the heading for a student's name and then collect his columns for Mon - Friday from each of the worksheets and combine them into one.