Excel tables work required

I have a workbook with 9 worksheets with 9 tables having the same structure. I want to create 10th worksheet that has the same structure and collect all data from the 9 worksheets, so that any change in the 9 tables will reflect on the 10th table direct.
If you are interested kindly type "et" on the top of your bid.