Combine two different Excel spreadsheets into one report

Hello. I have two Excel spreadsheets produced from a planning and scheduling tool called Primavera. The two spreadsheets have all of the information but I cannot produce one report with the information that I need in it and in the right format. Functionally, I need one spreadsheet to look up the necessary information in the other spreadsheet. This can be done manually, but it will take many hours every time that I need to produce a report which is once per week. I need an Excel Macro programme or Visual Basic which can read the first spreadsheet and then look up the missing date in the second spreadsheet and place the information in the correct position in the first spreadsheet. I need a small tool which I can use over and over again.