Is there a way to populate a summary worksheet with the details of 4 other
worksheets, all of which have the same number of columns (A:J with the labels
on row 5) yet have different numbers of rows (each sheet will have a
different number of rows with the data beginning on row 6 in each sheet).

Is it possible to do without running a macro so that the summary sheet will
look to be automatically populated with as many rows as there are on sheet
number 1, then look to be populated with as many rows as there are on sheet
number 2, etc.

Any help would be much appreciated.
Thanks
Tony