Copying data from external workbook into current workbook based on cell value

Hi,

Thanks for taking a look. The two workbooks are attached;

Variance Chart Current is the open workbook which contains the destination fields (yellow) for the financial data copied from the external workbook Financial Data (also yellow).

The Financial Data workbook address is highlighted in red and fields to be matched are in green.

I hope this makes sense.

Thanks,
Louise