Effort Calculation

Hi,

Please help me, how to implement the macro for Time sheet calculation, Please find the attachment, they are different name and different task with actual effort, so need to do macro, for Calculate the Effort and copy the name and Task into another tab.
See the Distribution tab, I given example.

through macro, Name should copy to another Tab and calculate the each person how many hrs spend in each task, those values go to another tab.
Names are repeatedly coming in data sheet, so we have to copy each person and total no hrs for each task.
DATA TAB, B Column is Task, Those name already i provide in distribution tab in 3rd ROW. So only we have copy the NAME and ACTUAL EFFORT.

i have lot of data with me, so manually calculating its taking more time, please help me.

Thanks