filter and copy filtered data to another sheet based on combobox selection

Hi,

I have been searching the net for my specific problem, but not finding the solution for it. I have two sheets of data. my data is in sheet2. it has an employee's daywise data in rows with each row corresponding to different months for him. and so on for each employee downwards. What I want to achieve is to have a combobox placed in sheet1 which lists the names of the employees. When I select a particular employee from that combobox, the data gets filtered in sheet2 displaying all those rows where that employee's name is written. And then, only that filtered data is copied to Sheet1 below my defined cells area. Actually I want to perform analysis on that data only in Sheet1, without my ever looking into sheet2 for it. Following is the setup of my data in sheet2:

Employee FIRM MONTH Day1 Day2 Day3 ........ Day4 Totals
ABC A Aug
ABC A Sept
ABC A OCT
LMN B Aug
LMN B Sept
LMN B Oct

I would really appreciate if the seniors and experienced ones here attend to my problem at the earliest. because I have been stuck on this for almost a week now. getting late. so would really appreciate your solutions.

thanx for your reply humdingaling. as for data validation or combobox option, i want you to review the sample file first,
and then, whichever is more efficient way than the other, it should then be used. my objective is to view the details and
summary easily. However, i would really welcome your better ideas for improving reporting of this excel file.