DavidA wrote:
Occasionally when a new budget is entered the links carry data into
the wrong summary worksheet cells and corrupt the total data

To enable us to help you I think we will need more information.
What is the formula in the cell that gets the "wrong" data.
What is the data in the cells that are referenced by that formula.
Why are you expecting something different?

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup