Merge Multiple Worksheets to One

Hello,

Very new to VBA so any help is much appreciated!

I have a workbook with over 25 worksheets, of these worksheets I would like to merge 16 of them to one "Master" worksheet.

These 15 worksheets are all in the same format with Row 1 being headings.
Each worksheet is created from a dynamic list of data.

I have found the code below which I have tried using however the problem with this is that it merges ALL worksheets I only want to merge the worksheets that I specify.

Please Login or Register  to view this content.

Thank you

If there's no logic in the naming pattern ("Data1", "Data2" etc), which would allow to be used in a looping function, you could declare an array with the worksheet names and then go just through each of those.

Please Login or Register  to view this content.

In your case that would be:

Please Login or Register  to view this content.