Copy Table

I am Using Excel a a sort of ERP system, not Ideal I know, but nevertheless.
My File exists out of mant Tabs, each for another subassembly oif a machine.

Each Tab contains a Table with a standard layout with the individual components.

I would like to make a main-page (the complete machine) in which name of the sub assembly is mentioned (is identical to the Tab name and only numbers)
If the Tab name is mentioned, the contents of the Table in the specific Tab must be copied to the main page.

There will be several sub assemblys mentioned on the main page, the tables all should be copied to this main page.

In that way I get a summery of all parts in the machine, which I can then add up with a "sum.if" function