Dear Experts

Need your help on the following

Here is Raw Data:

Sheet1

Name	Month	Salary	Location
A	1	100	M
B	1	100	M
B	2	200	M
C	1	100	M
C	2	200	M
C	3	300	M
D	1	100	M
D	2	200	M
D	3	300	M
D	4	400	M
My Requirement on Sheet 2

On the top of the sheet, there is drop down which contains list of Name from Sheet1
below that there are few row with the same headers mentioned above.

I' need solution for , if I' select particular Name from drop down example "D"
all below rows will fill with the records available for "D" in sheet1 i.e. 4 rows

Same if I' select "A" from drop down - I' should get only single row....

Thanks in Advance