Hi and welcome to the forum

1 of the 1st things you need to learn, is keep your headings in the same format wherever possible. For instance in Summary, you have actual dates (which are numeric), but on Report, you have just text. Then you can use this for the 1st column...
=SUMIF(Report!$A$4:$A$39,Summary!B$1,OFFSET(Report!$G$4,0,MATCH($A2,Report!$G$2:$R$2,0)-1,COUNTA(Report!A:A)-1,1))
and this for the "others"
=SUM(OFFSET(Report!$G$4,0,MATCH($A2,Report!$G$2:$R$2,0)-1,COUNTA(Report!A:A)-1,1))-B2