Linking data
 

I have spreadsheet that lists employee names and data relative to them. I
need to make a duplicate spreadsheet to continue the period of time w which I
am working. Is there a way that I can say...total the information from Bob
Jones on worksheet 1 with the information for Bob Jones on worksheet 2...
they may not be on the exact line on each page.

Thanks!