I need to copy two Excel 2007 worksheets (WS1 & WS2) from one workbook to
another (WBX & WBY). WS1 has a formula referring to WS2. When I copy the
two WS's from WBX to WBY, the formula refers back to WBX. I need to break
this link to WBX so that the formula in WBY WS1 refers only to WBY WS2. Is
there some simple way to do this?

I don't know how to use VB yet.