Create worksheet from data in another worksheet with lots of conditional or if...then ???? HELPT

Erol,

  I'm sorry but I'm  a little new to this kind of thing in excel.  I don't really understand how all that works.  So in the second sheet I already have the day, date, plan, etc, referencing the correct cell on the first sheet for each day because that is fairly static.  Will what you told me to do start at the top under "Sunday" and look for the first person listed under that day, list their name, unit goal, and dollar goal.  Then search again starting after that person and going down until they find the next person working etc until it finds them all?  It may not be possible but I'm hopeful.  Sorry again for not being more knowledgeable about this.

Thanks again,

Marc