Copy-paste tables from different worksheets into a common worksheet

[tgottsc1]

Hi guys,

I have a problem that I would be grateful if someone could please help me with.

I have tables on different worksheets, e.g. table_1 on worksheet one and table_2 on worksheet two. All tables follow the same structure.

I'd like to create a third worksheet where I copy all the information from table 1 and below that all the information from table 2. However, the number of rows may vary between tables, making it difficult for me to set this up in VBA.

My google search has not yielded the desired result so far and I would appreciate any help.

Many thanks!

Tim
Excel_example.JPG