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:

Sub Combine()
Dim J As Integer
On Error Resume Next
Sheets(1).Select
Worksheets.Add
Sheets(1).Name = "Combined"
Sheets(2).Activate
Range("A1").EntireRow.Select
Selection.Copy Destination:=Sheets(1).Range("A1")
For J = 2 To Sheets.Count
Sheets(J).Activate
Range("A1").Select
Selection.CurrentRegion.Select
Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select
Selection.Copy Destination:=Sheets(1).Range("A65536").End(xlUp)(2)
Next
End Sub