Auto add name in new sheet

[Kcbundy]

I’m part of an employee engagement team. We are sending out games/activities through email monthly and keeping track of participation. Each month the employee participates in, gets a “1”. If they don’t participate, the field is blank (or I can change to 0). At the end of the quarter, the number of times an employee participated, that number of times their name will be added to a list for excel to randomly pick a prize winner (I know this formula). What I don’t know is how to get names from “game participation” sheet to add to another sheet (sheet 2 at the time) each time they participated.
Ex: Polly participated in Jan and March of Q1. Her name will appear on the list twice. Jim participated in February so his name will appear on the list once.

 

[mumps]

It is hard to work with pictures. It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach screenshots (not pictures) of your two sheets. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).