When theres more than one of the same value in one column, what formula
would I need to use to add data associated with that value in corresponding
columns and display the results on a separate worksheet. The number of
instances can vary, so next time, Joe may have 3 instances, Sam 4.....

So that this on one worksheet:
resource hours

Joe 5
Joe 8
Sam 17
Peter 2
Peter 7
Peter 23

Results in the following on another worksheet
resource hours

Joe 13
Sam 17
Peter 32

Your help is appreciated