I have 2 separate workbooks. One is called 'Pack A' and the other one is
'Pack B'. 'Pack A' began with a worksheet called "December 2004" and it is a
very detailed sheet. 'Pack B' links to 'Pack A'. 'Pack B' also has a
worksheet labeled "December 2004". I would like to go into 'Pack A' and
create a copy of the worksheet "December 2004" then rename the copied
worksheet to "January 2005". I then would like to do the exact same process
to 'Pack B'. My problem lies in making "Pack B' "January 2005" link to 'Pack
A" "January 2005" instead of 'Pack A' "December 2005" no matter what I try I
can't get this accomplished. Is there anyone that could possibly help me,
please?