Extract and sum values based on Key Column

Hi,

I have table with following format.
-------------------------------------------------
Name ID Des1 Des2 Rate1
John 1 A A 2
Matt 2 B B 1
John 1 C C 10
--------------------------------------------------

I need to extract and paste all the unique records in to another worksheet.
If duplicate records found (based on the Column "ID") need to add the "Rate1" and put it as a one record. No need to consider other column values. (Only Consider ID and Rate1 columns.
Find the sum of Rate1 based on the ID and put the row details in to new worksheet.

Please help me to resolve the same.

Thanks
Remesh