title: Need help correcting a VBA/Macro code to combine multiple tabs into one
body: <p>I am new to VBA and have primarily used it in conjunction with creating a macro. As you can see from the code below, I am trying to take tables from three different tabs and merge them into one. However, I am having a hard time understanding how to ensure that each table will paste directly underneath the previous table and not overwrite it (especially when each month new rows are created).</p>
  
  <p>Thank you in advance for any help you can provide.</p>
  
  <pre><code>' Step_4_Combination_Tab Macro
  
      Sheets("Past Data").Select
      Range("A2:M2").Select
      Range(Selection, Selection.End(xlDown)).Select
      Selection.Copy
      Sheets("Combination").Select
      Range("A1").Select
      ActiveSheet.Paste
      Range("A1").Select
      Selection.End(xlDown).Select
      Range("A5483").Select
      Sheets("Actual").Select
      Range("A5:M5").Select
      Range(Selection, Selection.End(xlDown)).Select
      Application.CutCopyMode = False
      Selection.Copy
      Sheets("Combination").Select
      Range("A5483").Select
      ActiveSheet.Paste
      Range("A5483").Select
      Selection.End(xlDown).Select
      Range("A8341").Select
      Sheets("Forecast").Select
      Range("A4:M4").Select
      Range(Selection, Selection.End(xlDown)).Select
      Application.CutCopyMode = False
      Selection.Copy
      Sheets("Combination").Select
      ActiveSheet.Paste
      Selection.End(xlUp).Select
  End Sub
  </code></pre>