You can combine multiple worksheets to be one new worksheet with the Append Worksheet tool. These worksheets can be appended column by column, or row by row.
In order to access this tool, make sure a flat worksheet is active and select Worksheet:Append Worksheet to open the wAppend dialog. It utilizes the wAppend X-Function.
Specify the Recalculate Mode.
This part is used to specify the input worksheets to be combined. It includes a display box and a toolbar with four buttons :
Specify whether to append entire worksheet or specified columns.
This option is only available when Specified Columns is selected as Range. This part is used to specify the input columns to be combined. It includes a display box and a toolbar with four buttons :
Specify the direction to append worksheets or columns.