Merge multiple tables into one

Hello,

I have a file containing 3 sheets with 3 tables. Each table has same columns. Is it possible to combine all 3 tables into seperate sheet to another table?
And also I need for this table to autoupdate if any of those tables gets data added. For example:

ID NAME QUANTITY
1 AXX 7
2 AX1 8
3 AX2 8

ID NAME QUANTITY
4 AXX 7
5 AX1 8
6 AX2 8

ID NAME QUANTITY
7 AXX 7
8 AX1 8
9 AX2 8

And Final result is another table in another sheet looking like that:

ID NAME QUANTITY
1 AXX 7
2 AX1 8
3 AX2 8
4 AXX 7
5 AX1 8
6 AX2 8
7 AXX 7
8 AX1 8
9 AX2 8

Or try VBA: see attachment

Private Sub CombineWsh_Click()
  Dim wsh1 As Worksheet, wsh2 As Worksheet, wsh3 As Worksheet, wsh4 As Worksheet
  
  Set wsh1 = Worksheets("Sheet1")
  Set wsh2 = Worksheets("Sheet2")
  Set wsh3 = Worksheets("Sheet3")
  Set wsh4 = Worksheets("Combine")

    wsh1.Range("A:C").Copy wsh4.Range("A1")
    wsh2.Range("A2:C50000").Copy wsh4.Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
    wsh3.Range("A2:C50000").Copy wsh4.Range("A" & Rows.Count).End(xlUp).Offset(1, 0)
  
   wsh4.Activate
End Sub

[ deleted by me ]

I didn't notice thread is marked as solved