Count/Lookup with added info

Hi,

the attached spreadsheet lists employee ID's, names, and begin and end date for absences as well as the reason for absence code and description.

Is there a way to put a new sheet in that references this information and lists the following:

1) all people with 3 or more instances of absence (no matter how long)
2) all people with 10 working (not calendar) days or greater of absence
2) the amount of days absence for each instance for those listed in '1)' and '2)'
3) list the associated reasons for each of the instance for those listed in '1)' and '2)'

Any help is much appreciated.
Thankyou

dan