I am re-working a few spreadsheets, and in doing so am deleting multiple tabs. Many of these tabs are linked to each other via various formulas. Is there a quick way to automatically 'clear' or delete all the #REF's that pop up after deleting multiple tabs?

For example, say I have a spreadsheet with 4 tabs, tab 4 is the sum of column A for tabs 1, 2, and 3. I delete Tab 1, Formula #Ref's for every cell in Tab 4. Is there a way to automatically elminiate the #REF, other than going in, fixing the formula, and dragging and dropping across every cell?

Hope that makes semnse, lemme know if u have any wuestions.

Dom