Thanks. That got it. I received and error message first but that was
because the tabs in the destination workbook had already been renamed for the
days of this month. When I went back and simply named the worksheets 1-27 it
worked. Sure wish I had asked in the forum sooner!

"Niek Otten" wrote:

Save the workbook
EditMove or Copy Sheet, check Create a copy, New sheet
Save the new workbook
In the new workbook: EditLinksChange Source and select the new workbook

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"kjh4eyes" wrote in message ...
|I have two workbooks, call them Workbook A and Workbook B. Workbook A is a
| template that I use to track monthly sales, cash flow, etc. Each month I
| simply plug in the new dates on each worksheet. Worksheet B is the current
| month's report. I added a page with new formulas to the template (Workbook
| A). I now want to transfer that page to Workbook B. When I copy and paste the
| page from Workbook A to Workbook B all of the formulas refer to worksheets in
| Workbook B. I want to make those formulas refer to the worksheets in Workbook
| A so I don't have to go back in and reenter data. I know there must be a way
| to do this but I do not know what it is. Can someone out there help this
| Excel novice?