Consolidating data from one sheet to another

Hello,

I am attempting to consolidate some data from one worksheet to another. I thought I had a clue, but aparently not...

Sheet 1

Group 1
Group 2
Group 3

Sheet 2

Group 1 Sub A
Group 1 Sub B
Group 1 Sub C
Group 2 Sub D
Group 2 Sub E
Group 3 Sub F

I need to SUM the values in the Sub column on Sheet 2, into their Groups on Sheet 1. Sheet 1 has well over 200 rows, and more could be added. Sheet 2 has well over 500 rows...

What I was trying so far:

Private Sub Worksheet_Calculate()
If Target.Column = 2 Then

If Target.Value = Sheets("Raw Data").Column(H).Value Then
Cells(Target.Row, Target.Column + 1) = Sheets("Raw Data").Column("AN") + Cells(Target.Row, Target.Column + 1)
End If

End If
End Sub