Want to permanently Link cells on a new Worksheet to main sheet.

Hi guys
Hope you can help. I am pretty new to VBA (2007).
I created the a macro linked to a button that allows the user to create a new sheet "NewSheet". (This is just copied from a "Template" worksheet).
"Template" worksheet and the 1st sheet ("JobComparisons") are already set up with Defined Names.
Then, in the macro, I link the key cells on "NewSheet" to "JobComparisons" only to find that the data (values) are moved to "JobComparisons", but the link is not live.
i.e. when I update fields on "NewSheet" this is not reflected on "JobComparisons".
Obviously I need to do my link some other way. Can anybody help?

Dim ColRange As Range
Set ColRange = Worksheets("JobComparisons").Range("Col_Customer_Name")
ColRange(2) = Worksheets("NewSheet").Range("Customer_Name")

So - okay. Have realised I need to use something like "FormulaR1C1" and maybe "INDIRECT". Not quite sure how to do that.