Merge Multiple Worksheets into a Single Worksheet

How to Combine 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

todo:image_alt_text

Worksheet 2

todo:image_alt_text

Worksheet 3

todo:image_alt_text

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

todo:image_alt_text

Download Source Workbook and Output Workbook

Sample Code for Merging Multiple Worksheets into a Single Worksheet

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

Additional Resources