Hi,

I have a workbook called template.xlsx, and this has 3 sheets "template 1" "template 2" and "template 3"

I need to copy these 3 sheets into all other workbooks in a directory, there are about 45 in total. each of the 45 workbooks has EXACTLY the same sheet names withing the workbook.

It would need to copy everything from template.xlsx exactly, there are formula on template 1,2 & 3.

is this possible without me manually copying the sheets and changing all of the formula, as when i have tried copying manually the formulas link back to the original workbook the sheet came from.

Thanks in advance.