update sum when data changes based on 3 column unique id

[welchs101]

Hi,

i am enclosing a file to help explain what i am trying to do. I have a file with two sheets: Summary and Data. the data-sht is the raw data from which a summary is created and pasted on the summary sheet.

what i want to happen is when data on the "Data" sheet is changed/updated i want the summary data to update as well. Not sure how to do this given that the summary data table is a summary such where i am
calculating a total sum for a given (IDNum+ID_Psn+PI_Note). Not sure how to do this. I prefer not to use a pivot table but would rather use a formula if i can but if its only possible with pivot then i will provided i
can get table to look like i have now.