Consolidate data to summary sheet
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:D 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.
--
Ian
--
|