Copy excel datas from different work books to a common work book

Hi Techies!!!

I have a challenging task...can any one share me one VB code for copy excel data?

Below are my requirements

1) Source files may be diifferent work books, (so work book will be generate daily in a folder with date for eg:- 01.01.16, 02.01.16, 03.01.16,04.01.16)
2) Destination file will be common, so data from different source file want to copy in same work sheet.)

Would be very grateful to u,

Best regards,
MOhmmed Salim