updating destination when I add a line to my source workbook

[Guest]

I'm working on a budget and want to create a summary sheet that outlines my
last available $$ balances from individual workbooks.

Line from summary sheet:

Balance in shoe budget: (enter link to individual shoe budget workbook, Cell
F14 with current balance).

The problem is that if my original link was to: ='[Shoe
budget.xls]Sheet1'!$F:$14)
and I add a line, which causes my new $$ balance to be in cell F15, the link
won't automatically update. How can I do this without constantly updating my
source?

 

[Guest]

Have a static cell on each worksheet that contains a formula for the balance.
It should be set up so it wouldn't be affected by inserted or deleted lines.
Link to that cell. Better yet, name the cell 'balance' and link to the named
range