title: Copy Range from multiple workbooks in folder to Summary Workbook also in folder?
body: <p>I have a folder with 100+ workbooks.  These workbooks contain a range of data.  For simplicity I will call the data range A1:D2, the range is located on Sheet1 of all 100+ workbooks.</p>
  
  <p>I also have a Summary workbook.</p>
  
  <p>I would like to place VBA code in the Summary workbook that loops through the folder, copying the range A1:D2 of each of the 100+ workbooks.  </p>
  
  <p>I would then like to paste the A1:D2 range from each workbook in to Sheet1 of the Summary workbook.  Each paste will start on the next unused row.</p>
  
  <p>I am stuck doing this via a manual process right now and it is driving me insane.  </p>
  
  <p>I do know some basic VBA coding however my problem is that I can't figure out how to loop it correctly, and I am stuck coding each individual workbook to open-->copy-->paste-->close.  This was fine with 10-20 workbooks but now I am at 100+ and it is growing every week.</p>
  
  <p>Thanks again,</p>
  
  <p>Brian</p>