Create individuals' Timetables from Schedule of Global Data

Hello,

I have a spreadsheet with about 10 tables showing all the Courses, Classes, Classrooms, and Textbooks that a group of teachers will have. This is the global schedule. I'd like the teachers (or myself) to be able to create an individual's timetable by inputing their name on a second spreadsheet which then automatically populates the cells with the relevant scheduled classes. I attach an example spreadsheet with an indiviual timesheet input manually. Schedule Example.xlsx What formulas (or macros) do I need to automate timetable creation? Thanks very much!