Copy data to a different folder

Registration date
Monday November 9, 2015
Last seen
November 9, 2015
Hi All.. i need a macro to copy data from one sheet to another in a different workbook and folder.

There are 2 folders which contains files of same name in them.

I need a macro to find the files of same name and copy the data in the 1st sheet of that file in source folder to the 2nd sheet of the file of same name in the destination folder.

Can anyone please help me on this.

Thanks in advance