Drop-down for the selection of bank accounts to update balance sheet

i have 5 bank accounts which i use for various transactions. i pay the bills through all the accounts.
1. 5 bank names show opening balance in next column
2. in column a10, there is a list of bills to be payed.
3. column b10, shows the value of the bill
4. in column c10, i want to have the drop down list of bank accounts by selecting which the bill amount should get deducted from the opening balance of the respective bank shall also get updated

please help

thanks in advance

i have uploaded the file trying to explain the same.

in the first tab (balance sheet)main account details are mentioned with current balance

in the second tab (expenses). i have indicated 4 columns in each month. 1st is item..2nd is it cost, 3rd one- a drop down list for credit or debit.. 4th one- a drop down to select the list of banks in which we have to credit or debit.

every months balance statement should reflect back in the first tab again as indicated in their respective cells.

can this be possible?

that is wonderful!!!! been trying for so long.. this exactly what i wanted..

can you please explain the process.... when i click in debit or credit cell i get how you got the debit and credit drop down into balance sheet. but dint understand how you could link it to banks like hdfc and SBH-A and etc

well i have put the star also.. once again thanks for the solution