Macro to consolidate multiple files (1 Viewer)

Hi All,

I have set of file names saved in Sheet 2 of Consolidated file

I need a macro which will open the file names listed in Sheet 2 of consolidated file from "C:\Macro" folder and copy all data from A2 and paste it in Sheet 1 of Consolidated file and close the opened file and continue to do this for all files listed in Sheet 2 of consolidated file.

Example - Sheet 2 of Consolidated file contains file names "A.xlsb", "B.xlsb" and "C.xlsb".

When I run the macro it should look for file names in sheet 2 and open "A.xlsb" from "C:\Macro" and copy all data from A2 of Sheet 1 and paste it in sheet 1 of Consolidated file, then close "A.xlsb" and repeat these steps until data from all files are copied

Thanks in advance.

http://www.access-programmers.co.uk/forums/showthread.php?t=233117
I used a search keyword Harvest to represent Harvesting data from multiple Excel workbooks and then placing the data elsewhere.
Others posted some great links too in this discussion.
Perhaps this can proved some basic ideas, code and examples.