I have created a workbook for a preschool with one master sheet and all
others (classes) feeding from this one. What I need to do is create a
logic statement on one of my worksheets that creates an 'allergy list'.
It would need to generate a list based on the answer to one of the
columns in my master sheet.

For example: if (the particular cell in mastersheet says 'no') then do
nothing. However, if (the particular cell in mastersheet says
'anything but no' then:

Enter what it states in that cell here (example would be 'peanuts' or
'latex' or 'aspirin'), and in the subsequent cell enter the first name
of the student, in following cell enter last name of student and in
nextl cell enter the class the student is in, and in final cell enter
phone number of parent.

This worksheet would then have a master sheet of all children w/
allergies, what they're allergic to and their parent's tel number.

I haven't used exel in a while and am dumbfounded.

Any help would be appreciated.