I have two workbooks and would like to copy a page from Workbook A into
Workbook B. However when I do this the page I copy always references
Workbook A in the formulas. Is there any way to copy a sheet without
this happening?

example: formulas look like =[WorkbookA.xls]Data!D11
- I don't want the [WorkbookA.xls] included after copying, it should
just read Data!D11. There is already a sheet in the new workbook
titled Data that I would like it to point to.

Any help would be greatly appreciated!

Matt