Copy Excel Data present in common location to excel

Closed
Report
Posts
1
Registration date
Wednesday April 1, 2015
Status
Member
Last seen
April 1, 2015
-
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.