Sum based on variable text
 

I need to Sum values based on text. The text will be variable. The results
must show on a second sheet.
B8:B22 has the text that will vary on sheet one. Rows 8-22 in columns F-I
hold the values to be summed.
Course titles must then copy to C17:C24 and the summed total must show in D9
for column F, E10 for G, F11 for G etc.