I have a template in an external file which I am copying multiple times into another workbook depending on user requirements. The template contains formulas that reference other cells in another worksheet in the same workbook (call that sheet "source"). I have the "source" worksheet in the users workbook. When the user copies the template over, the formulas are referencing the original "source" worksheet, not the worksheet in their workbook. Is there a way to input formulas so they don't change when the template is copied over?

For instance, this is the original formula
="CONTRACTOR NAME ("&'Fill This Out First'!$C$1&")"

When the template is copied over, it changes to
="CONTRACTOR NAME ("&'X:\User Directory\User\2013\[Template.xlsx]Fill This Out First'!$C$1&")"

Want to avoid this.