build advance excel sheet -- 2

hi i have 10 customer and i need excel sheet where i can add data in 1 page and it will automatically transfer to selective customer so basically i can select 1 customer name on that sheet add data it will transfer to that customer sheet with time. automatically it will add all amount with % show total amount same way i will add debit amount that amount also deduct from that customer. its a sheet of credit debit with % and the % amount show in profit. that profit box is hidden and password protected. when ever we want to see any customer history just click that customer name below and see all hstory of transcation. Addition i can add over all daily basis opening amount and before closing that amount show with profit and total amount same amount accurate cash in hand. the opening amount is deduct with credit amount and add with debit amount. also on every transcation with empty reason box optional. need further discution ...... the calculation need 100% accurate .