Consolidating a list into another in the same worksheet

Good afternoon all,
I have a list of around 200 employees. Some receive bonuses and some do not each month. Payroll requires that I provide a list of only employees that receive a bonus for the month. Therefore, I'm trying to pull only those people from my original employee list that are receiving a bonus. This is going on a commission spreadsheet that must be used each month so I'd like to automate this.

Any ideas on how to accomplish this?

Thanks!
Blake

Need a sample of your workbook and then I'd be glad to help.

Thanks, I'm pretty new to the forum. What's the best way to provide?

Portion of spreadsheet

OK - just a few questions:
1) In cell B39, I find an employee name. Is this employee going to be the source of all data summaries for the sheet? I noticed that employee's name appears in cell B3 and that assistant's and associate names appear to be associated with him/her. What is the relationship, and how do you get data for the employee into the workbook?
2) in the range B26:D29 I see 2 entries for Billy and notice that his name and a total appears in cell J4, so I'm guessing that the range B25:D34 is for adding line item bonuses which are summarized above later. Does the range B25:D34 ever change in size? Where does that data come from? Is it manually entered?

Hi again,

I have attached a slightly revised version.


B38:N58 section will be repeated for each Loan Officer in the company. I added a second "Randy Krout" just so you can see. Each of these sections will be filled out by an admin. I want certain info to be summarized in the B1:M35 section. My issue is this: I want the B25:D34 section to ONLY pick up the names from I3:I23 if there is a bonus involved. So basically, I want the I3:I23 section to skip those that will not be getting a bonus that month.

Did I clear it up at all?

-Blake