data selected by validation 2 list

Hi,my data excel file have 2 sheets ,sheet1& sheet2. sheet1 is all data.
In sheet1 when i selected by validation with date & group ,it will return the data in the sheet2 .
by any way to do this,can some one help me the method and the code with the example file ,please.