software

I am using excel 2003. I have been asked to help create a March
Madness excel worksheet to track our company pool. I would like to
have a master file and a Template file to send out to my fellow
employees. I have a tab labeled quot;Templatequot; that will be renamed to
that person's last name in the template file. The problem happens when
I copy that quot;Last Namequot; tab into the master file. I would like that
copied tab to link to the quot;Masterquot; tab so that the point system is
updated correctly. The problem is when I copy the quot;Last Namequot; tab, it
still links to the quot;Masterquot; tab in their original file. Is there any
way to force the quot;Last Namequot; tab to always look for the quot;Masterquot; tab,
no matter what file the quot;Masterquot; tab is in?