i have a workbook with 10 worksheets labeled with employees names.

i am attempting to create a summary sheet to capture a snapshot of the time
spent on each task.

The worksheets are basically the same with some minor task variances.

I need to lookup tasks across the multiple worksheets and return the sum for
each task.

i.e., lookup "creating and posting requisitions" on every worksheet and
return the sum of all employees performing that task

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...et.f unctions