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