title: VBA Excel Copy Data from specific worksheet to a specific worksheet in another workbook
body: <p>I need to write a MACRO which copies a table from a specific worksheet, to a specific worksheet (Sheet 3) in a  master workbook, in the first empty row.</p>
  
  <p>Ideally I would like to have the MACRO apply to all files in a specific folder.  Pulling from different workbooks have a worksheet named "Sheet 3". ("Sheet 3" is just a placeholder)</p>
  
  <p>This is what I have so far:</p>
  
  <pre><code>Sub Master()
  Application.ScreenUpdating = False
  Dim erow
  
  Workbooks.Open Filename:= "C:\Example\File.xlsx"
  Sheets("Sheet 3").Select
  Range("A2").Select
  Range(Selection, Selection.End(xlToRight)).Select
  Range(Selection, Selection.End(xlDown)).Select
  Selection.Copy
  ActiveWorkbook.Close
  
  Workbooks("MASTER").Sheets("Sheet 3").Activate 
  'MASTER is the name of the Master Workbook
  erow = Sheets("Sheet 3").Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row
  
  Selection.Paste 
  'This is where the MACRO gives a "Run-time error '438': Object doesn't support
  'this property or method"
  
  Application.ScreenUpdating = True
  End Sub
  </code></pre>
  
  <p>Any help would be appreciated!</p>