Auto Merge 2 tables/worksheets 1 above the other

[Funkymonkey0073]

Hi All

I think I am going to look foolish after asking this as I think I am missing something blindingly obvious but here goes.

I have 2 worksheets that are identical in layout, one is 2018 & the other is 2019, both have the same number of columns with the same headings, they are both tables.

I want to auto merge/combine the 2 worksheet tables onto the same worksheet, one above the other so I can use it as a pivot table.

The 2018 data wont change so the number of rows will always be the same but 2019 can and will expand.

The 2019 worksheet is linked to another spreadsheet and will auto update on open adding any new lines that have been added to the original.

It seems such an easy thing to do but I am having a real brainfreeze on this one.

Any help as always is greatly appreciated.

Stuart

[PaulM100]

If both are tables, then the easiest way is in 2018 sheet, first empty row write =2019!a1 and drag right, f is table is should update by itself, otherwise drag all down and convert to table