Combine Multiple Worksheets into a Single Worksheet
The sample below uses the Range.copy() method to copy all source worksheets into a single sheet inside a destination workbook.
You can use any source workbook. For this example, we are using a source workbook which has three worksheets.
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
The following code snippet shows how to combine multiple worksheets into a single worksheet.