Pull Data from sheet 1 to sheet 2 based on content in sheet 2 using vba

I have a couple of reports I download on a daily basis.

One report is the employees name and badge number.
The other report is employees absenteeism.

The problem I have is the following:-

The 'Employee Absences' report does not show the employees full name.
The 'Employee List' does show the employees full name.

I need the sheet 'Employee Absences' to pull in the employees full name from the 'Employee List' sheet.

I then need to create a pivot from this information so I can keep a track of employees absences. (occurrences and total days).
I have attached a copy of the workbook.
The sheets within the workbook are exactly as the reports download. When you look at the reports you will understand more why I am struggling.

I would copy/paste the downloaded reports directly into the 'Employee Absences' and 'Employee List' sheets daily. Hopefully then run some code to give me the above.

Any help would be greatly appreciated.