Avoiding Reference errors when deleting and adding new worksheets

[johannagh@gmail.com]

I have several worksheets that compile and summarize the data from
different bond deals which each have their own worksheet. (In example,
I have worksheets named Combined, Outstanding, and Capacity that sum
the numbers from worksheets Issue A, Issue B, Issue C etc.)

I would like to be able to delete and add new bond deal worksheets
without having to change the formulas on the other worksheets.

Can anyone please suggest a function or way to set up the summary
worksheets up that won't give me #REF! errors everytime I delete and
add in a new bond deal worksheet?

I appreciate any help.

Thank you!

[Bryan Hessey]

It would be easier to amend the formulas before deleting the worksheets.

In Edit, Replace, Replace (tab), find BondSheet1, replace with BondSheet2, look in Formula, and Replace All.


Optionally you could retain the worksheet and Copy, Paste all data from the new to the 'old' (current) sheet.

Hope this helps

--

I have several worksheets that compile and summarize the data from
different bond deals which each have their own worksheet. (In example,
I have worksheets named Combined, Outstanding, and Capacity that sum
the numbers from worksheets Issue A, Issue B, Issue C etc.)

I would like to be able to delete and add new bond deal worksheets
without having to change the formulas on the other worksheets.

Can anyone please suggest a function or way to set up the summary
worksheets up that won't give me #REF! errors everytime I delete and
add in a new bond deal worksheet?

I appreciate any help.

Thank you!