Collating/grouping data from different sheets

that pivot table only contains 2 elements in the row field i put "names" in the data field i put "hours" (the label automaticaly changes to "count of hours") the column field is left blank
if you double click the "count of hours" you can change it to "sum of hours" instead
note if you already have a unique list of names
yoy could just put that in say col d then in col e put =SUMIF(A:A,d1,B:B) and drag down. just add any new person to list of names