Collecting Cell Values

[Cunner]

Hello there,

I have several sheets which give me results, e.g. "dummy1", "dummy3" and "dummy5" out of a list of all possible dummies 1 to 10. It is possible that there are any number of "dummy5" (or any other dummy) outcomes.
I just want Excel to make a list of all the possible outcomes.
In this case, I want Excel to make a List that says:
"dummy1"
"dummy3"
"dummy5"
This means Excel shall search the respective Columns and just check, is this dummy there or is it not.

Does anyone know how to do this?