I have 2000+ workbooks (A) in a folder (each having only one worksheet with data structured the same across all the workbooks). I also have another workbook (B) in a separate folder with:


  • The first worksheet structured the same as the 2000+ single-worksheet workbooks and
  • 4 additional worksheets that contain formulas that refer to the data from the first worksheet.


I would like to have a macro that loops through all the 2000+ workbooks (A) and for each workbook (A):


  • Copies data from the single worksheet inside it
  • Pastes it in the first worksheet on the other workbook (B)
  • Saves the updated workbook (B) as workbook (C).


Is that even possible?

Thank you very much.
dansor