I am trying to copy a worksheet A to another workbook. The original worksheet
A has formulas such as ='Store P&LE11, where Store P&L is another worksheet
in the same workbook. The new workbook to which I plan to copy worksheet A
also has a worksheet named Store P&L. I want the copied worksheet to retain
the original formula reference so that it will refer to Store P&L in the
destination worksheet. Instead, I am getting a link reference back to
worksheet A's workbook when I copy the worksheet to its destination. How can
I fix this?

Thanks.