How to link multiple excels into master file

[SusieW]

Hi have a file of employees time sheets that gets imported daily into my folder. Each day I get a new file with all the employees total worked hours in two columns one for hours and another for minutes the file is named "Summary and the date". I have a master file that I need this information transfered to on a daily basis. I want to be able to run a macro to insert the total hours worked by the employee by their name and department automatically instead of copying and pasting from each summary file.