title: User Selection (workbook and sheet name) then Copy and Paste
body: <p>Is there a way to make it where user selects which sheet to copy from, after they opened file?</p>
  
  <p>I'd like to do this because there may be multiple sheets with same format, but have different names. </p>
  
  <p>Example:
  Original workbook named <strong>VSC</strong> (Contains sheets <strong>Compare</strong>, <strong>Plot</strong>)</p>
  
  <p>Secondary workbook named <strong>SF</strong> (Contains sheets <strong>Results1</strong>, <strong>Results2</strong>, <strong>Results3</strong>)</p>
  
  <p>User clicks button on <strong>VSC</strong>, and file dialog opens, and user selects <strong>SF</strong> in a certain directory, then asks user to select which sheet to choose from - user chooses <strong>Results2</strong> sheet, copies the data (Range"B2:B5"), then pastes it back to <strong>Compare</strong>  sheet.</p>
  
  <p>Would this be possible? I am not sure how to start.</p>
  
  <p>Current code that asks user to select SF workbook:</p>
  
  <pre><code>Sub GetFilePath()
  Dim objFSO as New FileSystemObject
  
  Set myFile = Application.FileDialog(msoFileDialogOpen)
  With myFile
      .Title = "Choose File"
      .AllowMultiSelect = False
  If .Show &lt;&gt; -1 Then
      Exit Sub
  End If
  FileSelected = .SelectedItems(1)
  End With
  </code></pre>