Reference a row in a column?

In my attachment, I need to reference Row 5 on 'All Accounts' and show the results of those formulas in Column E of 'Account Listing'

So that if I change anything throughout the other sheets the formulas will take over, and I won't have to adjust anything on 'Account Listing'

If this isn't an "easy fix" then I can just copy, past values only, then transpose them in the column. But, if it's pretty easy, I'd like to have them reference correctly so I don't have to do that every time we change something.

Any help is greatly appreciated. And yes, I'm quite ashamed that I don't know how to do this.