linking data in excel

Hello, 

For work i have made a staff time sheet which calculates the amount earnt by hours worked for each staff member however, i require a table at the end of the document with the staff names and the total weekly wages for each person, due to the sporadic nature of the work people never work the same shifts and i am required to fill in the doc in the order which the staff have worked, is there a way to make excel take all of the information from "Josh" for example such as wages and add all of the days worked together and put it into a seperate grid? this is just a rough example down below