title: VBA open variable Excel files
body: <p>I need to create a consolidate workbook which open other excel files, copy and paste some tables.</p>
  
  <p>The problem is that the number of these excel files will change as well their names.</p>
  
  <p>For example I might have these files in one week:
  file A
  file B
  file C</p>
  
  <p>and these other files the week after:
  file B
  file C
  file D
  file E</p>
  
  <p>The consolidate excel workbook must be able to open all these files without making modification to the VBA code every time.</p>
  
  <p>Do you have any idea? Please write few code lines if you have a good idea</p>
  
  <p>Thank you</p>