title: Copy sheet from closed workbook to active workbook sheet with explanation
body: <p>I know this is probably very basic but I cannot find a consistent code which works. </p>
  
  <p>I am trying to copy the first and only sheet in a closed file on a shared drive location into the first sheet of the active workbook from which I want to run the macro from. </p>
  
  <p>If anyone can please share any help with an explanation of the code of the steps that would be great. </p>
  
  <p>Thank you </p>