Summarizing data from multiple sections

[tuppari]

Dear Excel gurus,

I have a workbook with data sections separated by an empty row, where I'd need to summarize some data to new columns, I have attached a workbook with two worksheets.

First sheet contains the data how it is currently, and the second worksheet is an example how the macro should summarize the desired data from columns D & E.

The rows per section vary from 3-6.

Please see attach example

example.xlsx

Edit: First sheet does not have the extra columns for generated numerical data, don't get confused by this