Summing Multiple Sheet Data to Master Sheet

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.

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

Welcome to the forum!

Please see our rules regarding thread titles. I have changed yours for you this time - next time you must make an effort to make it descriptive of your problem yourself, please. Thanks.

I believe that what you want will require VBA, if it can be accomplished using Excel. You may want to ask AliGW or one of the other moderators to move your post to that forum. I also believe that it will help if you include a sample of your workbook.
To upload a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window. Make sure there is enough data to demonstrate your need. Remember to desensitize the data.
Let us know if you have any questions.

To automatically get the values that are placed in column B of the 'Summary' sheet:
1) Select cell B5,
2) Paste the following array entered formula into the formula bar:

Formula:

Please Login or Register  to view this content.

3) Simultaneously press the Ctrl, Shift and Enter keys,
4) Drag the fill handle down to cell B51
Let us know if you have any questions.

If you activate the formula by simultaneously pressing the Ctrl, Shift and Enter keys then it displays 2800 in cell B6 and 400 in cell B31.
Here is a copy of the file with the formula applied.
Let us know if you have any questions.

It could be that your regional settings call for the use of a semicolon instead of a comma. If so change the formula to read:

Formula:

Please Login or Register  to view this content.

Either way:
1) Choose the first cell in which you want the formula applied
2) Paste the formula into the formula bar at the top of the sheet
3) Press and hold the Ctrl and Shift keys while pressing the Enter key
4) Only after doing steps 1:3 should you drag the fill handle through the other cells in which you wish to apply the formula.
Let us know if you have any questions.