Summarise monthly sheets into one yearly summary

[Red_42]

I thought this would be fairly simple, but I am struggling. I have 12 monthly worksheets with various headings such as Total, Purchases, Motor etc. Beneath those headings are daily entries and these are totalled at the bottom.

All I want to do is copy the totals from each month to a new sheet which will have the row headings:

Jan
Feb
etc

And the column headings from each sheet.

So there will be 12 rows of data and the a total at the bottom

Thanks

 

[Red_42]

Just bumping this up. Can anyone help?

I thought this would be fairly simple, but I am struggling. I have 12 monthly worksheets with various headings such as Total, Purchases, Motor etc. Beneath those headings are daily entries and these are totalled at the bottom.

All I want to do is copy the totals from each month to a new sheet which will have the row headings:

Jan
Feb
etc

And the column headings from each sheet.

So there will be 12 rows of data and the a total at the bottom

Thanks

 

[Red_42]

Message for 'Dave'. Sorry cannot send as had to delete as only can send 1 message

Its version 1804. Please message me again