Need help adding hrs on one name in many worksheets

[John Smith]

I have a payroll workbook that has many worksheets tabs for employees in
each department ...the problem is many of the employees move from department
to department and it is difficult to link the names to the totals sheet to
get the sum of the hours worked. Is it possible to have a formula to ID a
name no matter what worksheet he or she is in?

Thanks!

 

[BrianB]

Much better to have all your records in a single table in a workshee
and use Excel pivot tables/functions etc. to do any analysis
reporting. You then just add new records to the bottom and have Exce
do the hard work

 

[Gordon]

Much better to have all your records in a single table in a worksheet
and use Excel pivot tables/functions etc. to do any analysis &
reporting. You then just add new records to the bottom and have Excel
do the hard work.

Although I see you are posting from a forum, it would be nice if you could
please quote the post you are replying to, as a large number of people here
do NOT use that forum, and view this newsgroup with a news reader.

thank you.