How to use excel to consolidate data from one excel sheet into one table form

Hello guys! I have a question:

I want to consolidate all the data from one excel sheet into a table format. This is used for a scheduling purposes in a learning center to show which class is most suitable for the student.

What I have:
Excel sheet: Shows the suitable timings for different teachers for different students. (Attached as picture 1)

What I want: VBA code/ excel function
To consolidate this data into a timetable format (Attached as picture 2)
Constraints:
- The numbers in picture 1 = scores of the student. The lower the better suited is the timing for the student.
- If there are more than one class opening for the student, take the one with the lowest score
--> = minimum of both tuesday 1400 scores (of the two different teachers)


Please help me with this! Any form of help is greatly appreciated. Thank you so much!