Hello folks,

Just found out about this group and can see that there is a wealth of
experts and information here. Hopefully you can spare some time to
help this fellow out. Here is the situation:

I have a workbook with worksheets for every employee on a certain
team. On every employee's sheet, there are several statistical
categories that we track for that employee. I want to be able to have
pertinent data from each employee compiled on a summary page in the
same workbook. Once all this data is compiled on the summary page,
then I can create a Pivot Table to report the various statistics for
each employee, etc.

New statistics for each employee will be entered on a regular basis
(they are tracked daily), so I want the summary page to update as the
information is entered into the employee page. I don't want to
continually copy the newly updated statistics onto the summary page,
and don't want to adjust what cells are being looked at. I also don't
want the summary sheet to show a "0" if there is no value in a
particular cell it is looking at.

I hope this isn't too confusing. I thank you all in advance for your
help.