Write a vb macro to improve my excel ledger system

I have an excel file .xlsx which has around 7 sheets handling ledger handling. Cashbook ,Sales,Purchase,Expenses,Rent,Capital,Trial balance In this, cashbook is updated manually with user entering data to respective cells. As a result, other sheets get updated automatically with each ledger page pulling the data from cash book using “sheet!” mechanism. Because of this, some ledger pages have spaces in them between entries.. I need someone to write a vba code to have: 1. Userform (in VB) where user will enter daily transactions to cashbook. When one finishes entering a transaction, a button should be there for clicking This userform should also have a dropdown selection for which ledger page( sales,rent or expenses,......). 2. Through this process, updation should be done automatically in such a way that LEDGER PAGES SHOULD HAVE NO EMPTY ROWS. (this mistake could be seen in my screen shot) 3. Trial balance gets updated properly as the data flow from balances. So need not be changed 4. Plz help me with instructions as to how to add more ledger pages to the system such as dropdown etc . i have uploaded a doc file illustrating all the SHEETS. you will write vba code for these tasks.. please go through the screen shot and communicate with me.