CrossRef_Report

Analyse the data between 2 spreadsheets to create a new spreadsheet with merged information. I need to create a report which shows the staff who used the car park against the access control report. So if staff entered the car park on particular day I need to know from the staff list "access granted and the door name" It's only staff who have used a car by date from ANPR Sheet against "access granted and the door name" in Access. I hope this makes sense the only field that's the same in both sheets comes under "Cardholder name" in the Access sheet and "Forename" and "Surname" in the ANPR sheet. Could you provide an automatic process that would extract the data into 1 sheet similar to the ANPR sheet that can insert "access granted and the door name" from the Access sheet. into anything similar to example of idea.