Data retrieve from different file based on date

Originally Posted by littyjose

Hi

I need a urgent help from someone to solve this immediately. I have lot of excel file with 5 same columns on every file. The data will be generated daily and it will be separated by date. After generating the data I want to move particular date information from all the files to one sheet. How it is possible? If someone knowns please reply to me.

Thanks
Jose

Hi
the solution can better be provided if you attach sample workbook.