title: VBA to copy another excel file contents to current workbook
body: <p>This is what I want to achieve:</p>
  
  <p>I want to copy the contents of the entire first sheet in the most recently modified excel file in a specified directory. I then want to paste the values of this copy operation to the first sheet of the current workbook.</p>
  
  <p>I am aware there are macros to get the last modified file in a directory but I am unsure of a quick and clean way to implement this.</p>