I have a file with data in the same cells that I wish to copy into another
file. I have to do this constantly and wondered if I could achieve this with
a macro? The data I wish to copy is in various cells in the first file e.g.
A1, A2, A5, C1, C2, C5 etc, therefore I have named this as a range called
copy_data.

I then need to bring this into a seperate file into various cells e.g. cell
A1 from the first file needs to go into B1 of the second file. I cannot set a
formula up for this as the first file will be a different filename each time
(although the layout remains the same).

Does naming the range copy_data in the first file help or will I have to
relate each cell seperately to achieve this macro?

Any ideas as to the code required?

Thanks in advance.