Macro to extract data from different files

Hi,

I am looking for a macro to pull the data based on Date from the other files i.e Vijay.xls and Anand.xls
Is it possible to entered the Date using input box? or Date can be entered on the cell and have the results pulled from other files below rows.

Regards,
Vijay