Excel Budget Formula Help

Hey guys, I need help with this formula. Please see the screen shots. Basically I want the sheet to do the following,

When I enter a new transaction in the "Transaction Amounts" sheet in cell A9 and select the account in c9 and category in d9, I would like g9 to show the balance for the respective c9 account. Also, to deduct from the appropriate cells B3-H3. So for this screen shot, subtract 109 from cell e9 to account CCU credit which would be C3.

Then at the same time, I would like it to paste to the corresponding cell in the "Actual" sheet. So that would be 109 copied to Actual - Phone CCU Credit, but want it to paste in the date range closest to the transaction date.

If someone could help me that would be great.

I've attached the project to work on if you can help.

Thanks.
Kevin