Hi guys!

So, I have a template workbook. On this template is where I am making all the formulas and the format of the entire data.

Since I am doing statistics of different teams, I need to make several other workbooks. Some of them, I already made even before I use the template. The only reason I came up with the idea of a template is because I don't want to keep copying formula's from one workbook to another.

Now what I want to ask for help is, I know how to copy/move one sheet to another workbook. However, once I copy the template sheet to the real data sheet, the formula includes the name of the workbook where the formula came from. Is there anyway I can prevent this from happening? I mean, I have a lot of formulas from the template and is causing me some time to do it one at a time.

I tried to do the copy-paste thing, however, it works the same way as copying/moving the entire worksheet from the template.

I would really appreciate any answer! Thanks guys!

(This site is awesome by the way!)