Create drop down list, find, copy and add cumlative total

I can't seem to get any vba coding correct to do what I want to do, so any help would be appreciated.

After I paste new data in Sheet1, I am trying to create a drop down list of 'Site Name' in cell E5.
Then once I select a site it searchs sheet1 for an exact match copies and adds the cumulative total for the year across the sheet.
This is also done for the Org, Sub Division and Division.