Copy Hyperlink

I have a hyperlink on Sheet 1 that points to a named cell called "linkedcell" in A1. This hyperlink will fire a function. I need to copy the sheet multiple times and still have the hyperlink fire on the copied sheets. When I do copy it, the focus will be moved to cell A1 but the function is not fired. Any idea how to make this scenario work. The copies will take place via VBA so a many solution on every copy will not satisfy my requirement. Thanks in advance.