Saving template workbook multiple times

[daftwood]

Hi,

Basically I want to change a value in my template workbook, copy and paste values for all sheets, then save as a file name based on this value (which will be the same every time I run the macro). This process then needs to be repeated 20 times.

Any ideas would be gratefully received.

Many thanks

Martyn