I'm looking for a methodology to copy about 50 different cells contents from
one workbook into another one.

As I have to do this a number of times, what i am looking for is a
methodology that I can adapt to suit.

Basically what I thought I would do would be to enter the cell reference
from the original date onto a spare worksheet (in a column) as well as
inputting the taget cell reference into another column.

I therefore require code that will loop through both columns, picking up the
data from the reference passed and then copying the data into the second
workbook from the second reference passed

Hope i have made this clear and that someone can help

TIA