At work we have productivity sheets, we put the times we do a certain task.
The same tasks are not always done in order but we have to put them in order
of time. I want to link all the time totals for one task to another
worksheet (recap sheet). I cannot figure this out since they change location
daily. I want the task totals to add up on the other worksheet automatically.
Ex: worksheet one
taskA b-time e-time total
taskC b-time e-time total
taskB b-time e-time total
taskA b-time e-time total
taskC b-time e-time total
taskB b-time e-time total

worksheet two
totals added for taskA
totals added for taskB
totals added for taskC

remember the task change daily.
Thank you for any help!