Selecting specified sheets

[D-smoke]

Hello!

I am using a VBA code to compile data from multiple sheets (haven't written it myself as my knowledge in VBA is equal to a dung beetle). Currently it colllects data from all sheets and creates a new "combined" sheet.
What would I need to write/replace in order to:

1. Only select certain sheets to collect data from, e.g. sheets 2 - 14
2. Not create a new sheet everytime (set as "Combined" in the code), but rather clear and update an exisitng pre-set sheet (it could be called "Combined")
3. Automatically set the column widths

Appreciate any help I can get!

Here is the macro:

Please Login or Register  to view this content.

[xladept]

Just a little change:

Please Login or Register  to view this content.

[D-smoke]

Hi and thanks for your help!

This is closer to what I'm looking but if I run the macro a second time it doesn't just update the "Combined" sheet, it creates a new one that looks a bit weird. I want to be able to update the Combined sheet when changes are made to sheet 2-14.
Also, I will have a sheet already (blank the first time) that will be named "Combined" so the macro does not need to create a new sheet. Is that possible?

Thanks again for your kind help!

[D-smoke]

Hi again,

How unlikely it might seem, I actually managed to solve it myself Added some code to also create a table. Here is what the end result looks like.

Please Login or Register  to view this content.

Thanks for your help anyway! I'll set this as solved.