Sumproduct/sumifs?

I have to populate a spreadsheet with a similar layout to the attached example.

In the attached example I need to populate sheet 2 with the data from sheet 1. The 'name' determines which row the data appears in, the month under 'date' determines which column the data appears in and the 'value' is the data required.

The actual task has thousands of lines of data and spans over many years, so manually inputting the data isn't an option.

Can anyone help with a formula?