Combining two tables together, keeping correct format

I have two tables that I am trying to combine into one table while maintaining the correct format (Table 1 values highlighted green).

Table 1
A B C
1 2 3

Table 2
A B C
4 5 6

Table i am trying to achieve:
A B C
1 2 3
4 5 6

Table 1&2 are dynamic tables so the number of rows will constantly be changing.

Thanks for any help.

Hi impala096

See if the attached does what you want.
Also - you need to update your profile to show what version of Excel you have as .xlsm files don't work in 2003 Excel.