We created a new worksheet tab that we want to add to all of our previous
worksheets. Is there a way to copy the worksheet (with formulas) into the
new document without the formulas referencing the previous one?

All the spreadsheets have the same tabs, and formulas within these tabs
reference other parts.

We've tried copy/paste, paste special formulas, copying the whole tab by
right clicking, and drag and drop with both windows open. All of these still
reference the previous document, giving the formula

=MIN('[Old Spreadsheet.xls]multiplot'!N4732:N9128)

We want it to reference the multiplot tab within the new document, not the
tab from the previous document.

We're using Excel 2003.

Any help is appreciated, thanks.