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

Hi,

I've got a table of data which has to be refreshed from data held externally in another workbook.

The key steps would be;

1. The source financial data is held externally at an address that can change and I want to be able to state its location as a variable in the current workbook.

2. The data to be refreshed would exist in a specified range both in the current and external workbooks.

3. The process of refreshing data would use the cell value in a column of the range, one row at a time.

4. With each matching current workbook cell value, the corresponding row would be found in the external workbook and two values would be copied from specified columns on that row into specified columns in the current workbook.

I haven't got a clue how to start this and my research in the forum hasn't really helped because of my level of VBA experience.

Any help is much appreciated.

Thanks,

Louise