Example: My Name "RevBalance" has Workbook scope, and the following formula:
='Chase Acct'!$E:$E
I created it on the 'Chase Acct' worksheet; on the "Scottrade Chkg Acct" worksheet it should reference:
='Scottrade Chkg Acct'!$E:$E
and so on.

If I delete 'Chase Acct'! from the formula above, Excel just reinserts it. How can I make a formula relative the to current active cell, in the same way I can pick whether to use the cell below the active cell, or a specific row/column reference?