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?