Sum formulation problem

Hi everyone. I'm an intermediate-level formula user and understand basic stuff well. Have one need that is beyond my experience now.

Sheet 1
Column A has multiple instances of eight different values down 200 rows (and more added as I go - rows, not values; will always be one of the same eight in each new row)
Column B, Column D and Column E have values I'm interested in conditionally summing

County	Quantity	Date Requested	Qty Delivered	Qty Placed
Jefferson	50	Sep 5	50	28
Lake	30	Aug 31	30	30
Lake	50	Sep 15	35	23
Teller	100	Sep 1	100	100
Teller	100	Sep 15	100	78

Sheet 2
I want three different totals associated with Column A values in one row for each unique value of Column A

County	Requested	Delivered	Placed
Jefferson	50	50	28
Lake	80	65	53
Teller	200	200	178

Would like Sheet 2 to be locked and show me current information as I update Sheet 1

Your suggestions are much appreciated!!

?A

Thanks Everyone!! Worked perfectly