Dear Friend,
If you have that solution in forumal or Pasting Option, Becuase , some time the name can be shuffeled, that time the paste special option cannot be applicable in case if you do that it come wrong output
Jus Put Sum if Formmula for the each Row
=SUMIF($D$6:$D$13,E16,$E$6:$E$13)
Now automatically the exact amount will come, but one thing the same name cannot be repeated