Macro to copy some cells in some excel files in a folder to a master file

Good Morning Everybody

I am new to Macro Programming and I need help to accomplish a task assigned to me by my boss. I want a macro that will copy a particular cell such as "C2" in 5 different excel files in a folder to a master file. That is, all the values in cell "C2" in all the excel files should be updated serially to a master excel file. For example, assuming there are five excel files with names copy.xls, cut.xls, forum.xls, commercial.xls and point.xls. If the vaules in their cell "C2" are 2,3,4,5 and 6 respectively; I want a macro program that will automatically copy all these values, that is, 2,3,4,5 and 6 to cells A1, A2, A3, A4, A5 and A6 respectively in a master excel file called Consolidated.xls.

Any help pls.

This will show you the basics of looping through all Excel files in a Folder and copy a particular range from each Workbook to a Master Workbook..

The solution shown in the link below has a few extra things you don't need (like auto filtering and copying only visible range etc).. but you should be able to get the general idea of what to do...

http://www.excelforum.com/excel-prog...ml#post3439348