split one excel spreadsheet into many depending on constraints

[Nasson]

Hi,
I have an MS excel 2007 file having employee data.
I want to split the file based on the employee's performance.
For eg:
If there are 40 employees who received bonus, salary hike and promotion
then they should come in one sheet.

If there are 50 who received just promotion and salary hike but not
bonus should come under another sheet
So in this way the sheets should be created.

Please help.
Thanks!