Excel - Index/Match/Vlookup function

[Riaan1055]

Morning guys
 
Hope all are doing well.
 
I need help with the spread sheet. Helping someone.
 
attached are the sheets. 
 
I need the clocking times from "clocks" file to pull through to the covid-19-register.
 
in the register will be all the info of the employee working onsite and in column AW today's date following by clock in time.
 
the time that are in the "clock" file needs to pull through to that cell matching the employee's name in the first column of the register.
 
Please 
 
 
Thanks
 

[#2]

@Riaan1055 

May I quickly suggest that you remove those files from this thread--they contain real names of real people, which we try to avoid here--and post instead a couple of sample files that still illustrate the problem. We don't need full files--definitely don't need all those clock files in that ZIP file--in order to demonstrate how you could link one file with another.