I am hoping that someone can suggest a methodology to perform a simple task
of copying data from one file into another.

The copying I need to do is this

Copy From Copy To
File A File B

Sheet 1 Cell A1 Sheet A Cell C1
Sheet 1 Cell A2 Sheet B Cell D1
Sheet 1 Cell A3 Sheet A Cell C2
Sheet 1 Cell A4 Sheet A Cell C4

The list has a lot more entries than the 4 entries shown. The data is always
copied from the same sheet in file A but has to be pasted to either of 2
sheets in File B


Cheers

Gazza