I'm fairly new to this and am having difficulty trying to solve what to me
seems like an easy problem!!!! (spent hours on line searching)

I want to import data in specific cells from one sheet to another sheet in a
different workbook using VBA

I don't want to link the two files and I'm hoping to avoid using loads and
loads of code. (as this makes it difficult when changes have to be made.

I could use the macro recorder and copy contents of cell A1 and paste it
into cell C3 in the second book and so on. But there are more than 80 cells
i want to copy from the first worksheet to the second - there is a set
pattern e.g. cell a1 to cell c3, cell a2 to cell d5 (obviously too many to
list here)

I would like some form of solution that lists the from and to cell
references on a spare worksheet and uses these lists to pass values that VBA
can loop through (struggling to gert to grips with single loops let alone
using 2 together)

Any suggestions appreciated