Trouble finding the right formula to move text from register into expense code cells.

I will attach a file for better clarity.

I have a spreadsheet with columns B:F being used like a check register. In multiple cells from H:Z, I have expense code budgets, with the top portion showing what I started with for the month. As I enter the data into the register, I would like the transactions to copy over to the budgeted items and reflect remaining amounts. Just like a checking account but all on one page. I am using a Sumif formula to move the data based on the expense code entered into the register, this will move the date of the transaction, and the amount either debit or credit. I am running into two/three problems. Problem one, I can't get the transaction item (name of store/company) will not move to the transaction cell in the expense code section (I haven't been able to find a formula to help me). Problem two, I need for the next row to capture the next transaction. I have been using the same sumif formula but having a different range for each row to pick up the next transaction. This can be a problem if a new transaction is entered directly under the previous one. Problem three, I cannot add another sheet to transfer data to because the workbook is getting to be a bit large as it is. Currently I have 18 plus tabs and would prefer not to add another.

Is there a way to do it only using formulas??
Thank you,
Edmat