dear all

I have a sheet and making of this sheet was done with the help of members of this forum.
I need some more help setting up this sheet.

Sample file
need-help-auto-arranging-of-data-in-different-sheets.xlsx
A. in the attached sheet I have created six tabs. when I enter data in "2015" tab, the data is copied automatically to the appropriate month tab. but in this sheet I have a problem that the data is not sorted. now the thing I want is the data to be sorted automatically when it is copied.

B. the second thing I want to do is that if I enter the amount in "if cleared" column then the data in that row be copied to the last empty row and in the credit column of the "account" tab.

C. when I enter any data in the "deposits" tab then it should also copied to the last empty row and the debit column of the "account" tab.

D. and also when the data is updated row by row I want the balance of my account be updated in the last column of the "account tab"

in brief I am going to enter data in just two sheets "2015" and "deposits". an I want all other sheets to be updated automatically. further if I edit the data in these two sheets the data in the other sheets be edited automatically.

any help will be appreciated.

thanks in advance