how can I group information from more than one worksheet
 

I want to produce an individual daily stats sheet for a group report. How do
I ensure that the correct data is being transferred as the agent doesn't
always appear in the same cell on the group report. (Due to absence or
holidays etc.)