Excel 2007 : Listing values over multiple sheets (INDEX)

[Fieldsinc]

Exaplme.xlsxI have 7 worksheets containing employee names, the column to the right of each name is the value I wish to list. A employee may or may not be on all worksheets, sometime they will show twice on one worksheet. Or 2 times on all 7. I got a index formula to look over 2 worksheets but not sure where I need to add the 3rd and 4th .... Worksheets information in the formula. All employees names are in the same column over all worksheets. As well as the values I'm trying to list.

On the example, i have it to show data for the first 2 sheets... Hood River and North Coast. I would like it to show all data that meet the criteria "Chris" from all the sheets. Where do i enter those new sheets information in this formul?

Thanks

[JBeaucaire]

You'll need to show us this problem, the verbal description is too vague.

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. Make sure you demonstrate good sample data and manual mockup of the results you're trying to achieve from the sample data.