Auto Filter and Sum Macro

Hello- I am looking for some help on a macro.

Attached is a spreadsheet with 2 tabs.

First tab is where people will add rows and fill information under columns 'name' 'jan', feb'....'June'

The second tab shows the desired results of a macro. Here the data from tab 1 is FILTERED and then SUMMED under the filtered name set (in red).

Is it possible to create such a macro?

Thanks for any help