Summing Up Data to a Mastersheet

[Sotiris_Soteriou]

Hi to all the members

I have 7 sheets in my excel work book.

Sheet 1 is called Cash
Sheet 2 is called Cheques
Sheet 3 is called Transfers
Sheet 4 is called Online Payments
Sheet 5 is called Bank
Sheet 6 is called Data
Sheet 7 is called Summary. In this sheet I have running down the columns all the accounts we use in our General Ledger, and running on the top rows, the months January to December. What I would like to do is, run a formula that will TOTAL the Cash Sheet according to an account with the totals on the side and give me the figure on the Summary Sheet.

Summary Sheet
CASH CHEQUES etc etc
2350>030 (Clearing) 1500,00 2000,00 <---------- these being the totals of account 2350>30 from each of the above mention sheets
3200 (Bank Charges) 150,00 300,00 <-----------these being the totals of account 3200 from each sheet.

Please remember that there are multiple references in the sheets above mentioned sheets. All references to this account in each sheet must be totaled before summing them up to give a consolidated figure in the summary sheet for each account.

l hope I have given enough details for someone to please help me as I am struggling to get this sheet done.

Thank you all in advance