title: Open multiple Files and perform macro on all opened Files
body: <p>I want to write a macro that will open 30 excel files which all have the same structure. </p>
  
  <p>The macro should do operation on all files, and take the results from every file and put it in another excel file.That means: all Results (Values) will be copied into the destination file.</p>
  
  <ol>
  <li><p>How do I write VBA code to open multiple files?</p></li>
  <li><p>How do I take the results from every file and place them in my destination.xls file?</p></li>
  </ol>