Extracting info from different workbooks

Hi

I'm trying to automate the paperwork in my office but running into problems.

Workbook 1 "Route" contains a sample of the drivers route which is not adjustable. Workbook 2 Sheet 1 contains details of the days deliveries emailed in from another office. At the moment this is then cut and pasted into each drivers delivery sheet.

Is there any way the info in Workbook 2 can be inputted automatically into Workbook 1 "Delivery" once downloaded. I've played around with vlookup and index/match but being untrained in Excel soon got totally lost.

I think what I'm after is - If a Site ID appears in Workbook 1 Route Col A and Workbook 2 Col C, then enter Site ID in Workbook 1 Delivery along with all data from Workbook 2 Cols E to N

Any help would be appreciated.

Hope this makes some kind of sense!WORKBOOK 1.xlsxWORKBOOK 2.xlsx

Workbook 1 is totally empty. Is that intentional??