Excel 2007 : Comparing two sheets

[PONJO]

Good Day

I have a workbook with multiple sheet but my objective is to compare the "Summary worksheet" (Column B) to "Worksheet Current Date" (Column F or G).
If the name value is a match then addup "Worksheet Current Date" (Column B and C) to " Summary worksheet" (Column D and E), Please note both worksheets have two section, Fund Manager and Stockbroker section.
All this must happen on a click of a button, I hope I was clear enough for you to understand.
I've attached the file for eas of reference

kindly note am new to programming so detail explanation will be appreciated.

am willing to give some incentive if need be

thanx

[arlu1201]

Whatever action is performed in the fund manager section, it should be performed in the stock broker section? What if the same name in column B in the summary file is present only in 1 section?

[PONJO]

yes if only Summary file column B <> 21 May file column F/G then take values from 21 May column B and C addup to summary file D and E (buyers) or column F and G (Sellers)