Search value in same cell of different worksheets. Copy when value found

[pjmv]

I’m trying to create a timetable for the different classes of my school.

The classes timetables will all be located in the exact same cells of different worksheets.

Each class period (8h:30m to 9h:30m, for example) will have the info in 3 cells of the same column:
C8 - Discipline_code
C9 - Teacher _code
C10 - Classroom number_code

This is easy...
What do I need? To create the teachers, timetable by searching the different classes timetables. I will create a worksheet for each teacher.
In that worksheet, i need a formula that finds If in cell C9 of the different classes timetables Teacher_code is found, copy the value of the cell above (Discipline_code), to this cell.
Thanks in advance