Feed Data from Multiple worksheets to a Summary Worksheet

[BT1113]

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.

 

[daregreatly]

with each employee having a different sheet... do all cells of
interest on each sheet have the same type of info?

like...
sheet5(joe) cell(B9) is their process rate..
sheet6(bob) cell(B9) is that same process rate but for bob?
same for all sheets? and all cells in those sheets?

 

[Guest]

Another thought ..

If your multiple source sheets are identically structured,
perhaps this sample from my archives might have relevance:
http://savefile.com/files/414328
Interactive Summary.xls
(nicely rendered, full details inside)