Sum staff hours in a work sheet

[rockyoz]

Hi Masters,
I was working on a timesheet and just want make a automatic updated summary sheet. here are the original sheet.

StaffName Date Hours
aaa 1109 5
bbb 1109 6
aaa 1110 5
ccc 1110 4

I want in sheet 2, it can become like follow

StaffName TotalHours
aaa 10
bbb 6
ccc 4

This is for my colleagues that do not know how to use Excel, but know how to copy and past. The idea is when they copy the sheet given to them to sheet 1, sheet 2 shows the content automatically. It is hard to train all of them so I just want make it easy to them.

I tried Record Micro, still you need press the key to do it, and considering the following support, it may not be a good choice.

Currently this is my plan to go with Formula,
1. Use true false label the redundant and find the criteria for sum later on.
2. Use true false to copy the non-redundant names to sheet 3 to create the criteria.
3. Delete the empty row in criteria area or copy it to new place to skip the empty row(I DO NOT KNOW HOW TO DO THIS).
4. use criteria to do the sum.

Can somebody let me know how to do the step 3 or if you have any suggestions(use formula only) it would be greatly appreciated!
P.S. I know PivotSheet can solve this easily, but I don`t want any human click on it.

 

[Sektor]

Use PivotTables.

 

[rockyoz]

Use PivotTables.

I know Pivotables can do it. But then I need teach everyone to learn it. For my colleagues it is not easy.
That is why under my P.S. I said no Pivotable.
Still, thanks very much for your reply.
The ideal is no human interaction after paste.