title: Copy data from a sheet in one workbook and paste into a specific sheet in another workbook
body: <p>I am trying to write a macro that opens an import file dialog box, has a user select a file, and copies/pastes the data from a specific sheet from one workbook into a specific sheet in the open workbook.</p>
  
  <p>This is for a summary report that requires additional data from multiple workbooks. </p>
  
  <p>I'm a little new to VBA, so I can't get it quite right. I can get the file to import into a different sheet, but not into a specific sheet. Any help would be appreciated! If there is a way to do this without macros, I'm open to that as well. Thanks!</p>
  
  <p>Here is my current code:</p>
  
  <pre><code>Sub importDataFromAnotherWorkbook()
      ' Get workbook...
      Dim ws As Worksheet
      Dim filter As String
      Dim targetWorkbook As Workbook, wb As Workbook
      Dim Ret As Variant
  
      Set targetWorkbook = Application.ActiveWorkbook
  
      ' get the customer workbook
      filter = "Text files (*.xlsx),*.xlsx"
      Caption = "Please Select an input file "
      Ret = Application.GetOpenFilename(filter, , Caption)
  
      If Ret = False Then Exit Sub
  
      Set wb = Workbooks.Open(Ret)
  
      wb.Sheets(1).Move After:=targetWorkbook.Sheets(targetWorkbook.Sheets.Count)
  
      ActiveSheet.Name = "ImportData" 
  End Sub
  </code></pre>