title: Merging first sheets of multiple excel file into another sheet
body: <p>We have three files, File 1 &amp; 2 contain data at Sheet 1. In File 3, Sheet 2 has a button and a table (containing file 1 &amp; 2 details such as filename and path):</p>
  
  <pre><code>File 1
  ABC 123
  
  File 2
  BAC 321
  </code></pre>
  
  <p>After clicking the button at Sheet 2, a macro should fetch the data from Sheet 1 of File 1 and 2 and should place them in Sheet 1 of File 3 as shown below:-</p>
  
  <pre><code>File 3
  ABC 123
  BAC 321
  </code></pre>
  
  <p>I have found few codes using following functionality to do the same, but they will work only at the sheet the code is in.</p>
  
  <pre><code>arg = "'" &amp; path &amp; "[" &amp; file &amp; "]" &amp; sheet &amp; "'!" &amp; _
        Range(ref).Range("A1").Address(, , xlR1C1)
  '   Execute an XLM macro
      GetValue = ExecuteExcel4Macro(arg)
  </code></pre>