How to create a dynamic dropdown based on multiple lookup conditions

I need some help with creating a dynamic drop down. I'm stumped as to how this can be achieved. Thank you for your help in this!

I have two worksheets. The first worksheet contains the names and their Available Times and Days.

On another sheet, I have a course name and the time and date of the course. I want to be able to select an engineer to attend the course based on the conditions that the engineer is available on the said day and time.

Training Tracker Test.xlsx