How to copy the contents from the sub files to the master worksheet based on the id?

Every Friday I receive about 50 excel sheets titled time utilization along with their id (eg: timeuti-1001, timeuti-1002, etc) from my classmates. Currently I am physically copy-pasting the details that they send. I would like to automate this task.
I am saving all the files in C:\timeutilization.

When I click on the ‘Reconcile’ command button in the mastersheet which is in the same folder. I want the macro to identify the student id from timeuti-1001 filename and for that particular student id I would like the macro to match it with the student id cell in the master sheet and copy the contents of the cell for that particular student id.

Eg: Student with filename “timeuti-1007” sends the details this Friday.
pic1.JPG
I would like the mastersheet to look like this:
pic 2.JPG

For every student it needs to update it based on their id. If an user has not sent the details let the row remain blank. Thanks in advance.