Append

Append a previously saved table, or the contents of a worksheet in the same workbook, to the current table in memory.

Append From Table – select a previously named table from the drop down list. To save a table in memory, use TableName.

Select a table from the dropdown, or get the table name to use from a worksheet cell reference.

Append From Worksheet– select a worksheet name from the drop down list. Note that the worksheet must contain data in columns with a header row starting in cell A1. The entire worksheet will be appended.

Select a worksheet from the dropdown, or get the worksheet name from a referenced cell.

Related: Using the Append Function