Carry a balance to new worksheet

Hello all! I am hoping someone can help me with a little issue I am having. I have an excel spreadsheet that I use as registers (like a check register) for all of my bank accounts in order to keep my accounts balanced. I have 7 different bank accounts. In excel, one worksheet has a register for each different bank account. The register keeps a running balance of the accounts for me. What I would like is to create a new worksheet that I can go to and see what the current balance is for each of my accounts. I want this new sheet to update when debits and credits are added to the register.

I have attached an example of the excel spreadsheet to provide a better idea of what I am working with. If you have any advice, I would appreciate any assistance in building this.