Dear Experts,
I have 28 separate worksheets (classes of drugs) and from column O on each
of those worksheets I want excel to look down the column and detect when
there is text entered (drug name) and record it in a separate sheet. At the
end of the day I want one sheet which collects those occurences of text in
column O and lists them on the Summary Sheet. I should then have one sheet
with certain drug names (meeting a particular criteria) from 28 classes of
drugs.

Column O may have 100 rows but only 16 entries of text. I only want the
text collected.

Is this possible?
regards
Martina