How can I determine which sheets meet criteria?
 

Hello,

I have a workbook with 250 sheets plus a summary sheet. In cell B2 on every
sheet is an ID number that is either 6 or 8 digits long. I need to know if I
can generate a list of which ID numbers (which sheets) meet a specific
criteria.

For example; the summary sheet shows there a 24 MID-LEVEL MALE
TERMINATED. How do I find out which 24 males are mid-level and terminated? It
looks like this on the summary:

MID-LEVEL

TERMINATED: MALE 24
FEMALE 9

If this is possible, I would need to be able to determine which sheets apply
for any number of combinations: male/female, mid-level/level 1,
active/graduated/terminated/pregnant.

I've gotten a lot of great help from this site with the formulas, etc. I
needed to set up this workbook. Now I'm being asked to show which people
represent each total listed on the summary page if needed. I need a list of
the ID numbers instead of names for confidentiality purposes.

Thanks in advance for any tips, advice or help you may have.

tgcali