Hello All

Please excuse me for an unclear subject. I will try to decribe my problem as
clear as possible.

I have a spreadsheet which helps me measure productivity of my staff. I have
three departments (BULK, FLAT PICK and HANG PICK). Each spreadsheet contains
following::
NAME | TOTAL PICK | TOTAL TIME | AVG UPH | TARGET |
John Doe 10,000 100 100 120

I have a list of over 200 employees with these figures. I am trying to find
a way to force excel to identify people who are not reaching the target
(which changes every week depending on the type of product comming through
the door) group them all in one table on a separate tab which I can hand out
to Team Leaders.
Please remember that I would like that info to be shown on a separate tab.

I know a bit about excel but this is simply out of my league.