Consolidate data to summary sheet

[Ian]

I'm sure this is an easy task, but I'm not sure where to start.

I have a workbook with a number of worksheets. The number of sheets will
increase over time.

I need to produce a sheet combining certain columns from all the other
sheets. How can I do this?

eg On sheet "Summary", starting on row 2 I need the data from sheet "John
Smith" columns A row 2 to the last occupied row. Under this data on
"Summary" I need the equivalent data from sheet "Tom Jones" etc.

I hope this is clear.

 

[Joel]

for each sht in Thisworkbook.sheets
if sht.name <> "Summary" then
SumLastRow = Sheets("Summary").Range("A" & Rows.Count).end(xlup).Row
SumNewRow = SumLastRow + 1
ShtLastRow = sht.Range("A" & Rows.Count).end(xlup).Row
sht.Range("A2" & ShtLastRow).copy _
destination:=Sheets("Summary").Range("A" & SumNewRow)
end if
next sht