Repeated copyinf from multiple files to 1 file

[grmusselwhite]

Hi,
I have a set of templates which I need to update into a new one. The templates are exactly the same in terms of their layout and what needs to be copied over.

I have recorded a macro to do so and currently would need to go into the macro and change the name of the source template being looked for, and then save the destination template as the same name as the source one each time.

Is there something I can add to my macro that will do this for me?

 

[BrianB]

Like this ... ?

http://www.mrexcel.com/board2/viewtopic.php?t=145246&highlight=