Merge Multiple Worksheets into a Single Worksheet

Combining Worksheets

The sample below uses the Range.copy() method to copy all source worksheets into a single sheet inside a destination workbook.

Source Workbook

You can use any source workbook. For this example, we are using a source workbook which has three worksheets.

Worksheet 1


Worksheet 2


Worksheet 3


Output Workbook

Running the following code provides a workbook with a single worksheet containing the data of all three worksheets.

The output worksheet now contains the data of all 3 source worksheets


Download Source Workbook and Output Workbook

Code Example

The following code snippet shows how to combine multiple worksheets into a single worksheet.

Additional Resources