Updating another spreadsheet based on certain information and certain conditions

[Ab_C]

I think this might be a bit of a long shot as I'm not sure it's possible, but thought I would see if anyone on here could help!

I am trying to find a way to link two spreadsheets - one is a week long timetable and I would like the information from this to automatically update another spreadsheet, so that the people teaching can see a list of the dates relevant to them, but I think this would involve applying conditions that are a bit beyond me.

I've attached examples of the two sheets:

'Timetable' is the main spreadsheet which stores the information and is the one which the information will be typed into.
'Dates' is the spreadsheet which will be updated by 'Timetable' and has a tab for each person named on the timetable. I've laid out the first few tabs how I would ideally like them to look, although it's divided into 15 minute time slots and I'm not sure how that would work. Basically, each teacher's tab would be updated from the data stored in timetable, to give them an overview of what they alone would be teaching that week.

I'm not sure if that makes sense or if I've explained it very well, so please do ask if you have any questions.

Huge thanks in advance for any advice or help you can give.