title: How can I extract data from multiple files in a folder of excel
body: <p>I have 140 excel files in a folder that have the same identical format, and in each file have a sheet name called “data” (which is hidden) where I have information range c2:c12. I need a macro to extract all the data from these 140 excel files in a folder and should be pasted in my summary sheet in row wise. (the information extracted from C2toC12, has to transpose) each file information should be pasted row wise.</p>
  
  <p>Example: C2 = File Name, C3=Name,C4=Father Name,C5=Age and etc.. upto C12</p>
  
  <p>All the extracted information should be pasted into my summary sheet with transpose (row wise)</p>
  
  <p>Note: while extracting the data, I have already the path from where it has to extract and which is in my summary sheet “E1”</p>
  
  <p>Any help in pointing me in the right direction here would be most appreciated</p>