Copy Excel Data present in common location to excel

krish7 Posts 1 Registration date Wednesday April 1, 2015 Status Member Last seen April 1, 2015 - Apr 1, 2015 at 07:37 AM
Just a beginner with macro... no experience at all...
Here is my problem...
I have some excel sheets placed in a common folder in my local disk.
There 100 excel sheets with different names and each has three sheets within.
I want to extract some data from sheet1 of each sheet and make a summary of it.
Sheet 1 data is of 2 columns and 5 Rows.
1st column is common to all the excel sheet...only 2nd Column data differs.

can someone help me with the macro code for this problem. since opening each excel sheet and getting data is very difficult task.