VBA copy data within a range of sheets to a summary sheet

[andybhoy]

Hi,
can anyone help me with the following problem?

I have a file with lots of sheets but I only want to copy some of the sheets to a summary sheet showing each line item that was copied.
I have set up "first sheet" and "last sheet", so I would be looking to copy the same range of data from each sheet ( say A1 to z100) that is located between the first and "last sheet" and ignore all other sheets not between these two.
The do not know the names of the sheets between the sheets "first" and "last", and I do not know how many sheets there is to be copied.
I would like to copy all the info into a summary sheet, but keep putting the info below the previously copied sheet.

Any help or advice would be greatly appreciated.

thanks

 

[VoG]

Try

Sub test()
Dim First As Long, Last As Long, i As Long
First = Sheets("First").Index
Last = Sheets("Last").Index
For i = First To Last
    If Sheets(i).Name <> "Summary" Then Sheets(i).Range("A1:Z100").Copy Destination:=Sheets("Summary").Range("A" & Rows.Count).End(xlUp).Offset(1)
Next i
End Sub

 

[andybhoy]

VoG,
thanks for your help and the very swift reply and the code works a treat.
cheers
A.