Formula to sum multiple values from table if values in other set of cells matches criteria

Hello gurus,

I've attached the file I'm attempting to work with for reference.

I'm trying to create a formula in cell C14 that looks at the values in cells A8:A13, matches those values against corresponding data in the HC and CS per HR table, to sum the values from column D of those matching data points, kind of like a multiple vlookup/sum of lookup results, does that make sense?

Suggestions would be greatly appreciated!

Thanks in advance you beautiful minded geniuses :-)

George