Dear All,

I have 10 rows of single columned data in identical places on three
different worksheets, in the same workbook. (ie. I have 30 cells of data -
10 cells by 3 sheets).

I wish to loop through both the 3 worksheets and the 10 celled range and
collect their data, then in place this data in a single row on a fourth
worksheet.

For some reason (basically not yet skilled enough!!) I can only seem to loop
through the 3 workbooks and only collect the data from the last sheet (ie.
collect only the last 10 cells).

My array needs to accommodate 30 elements, I'm just getting the last 10....

The first 3 sheets are basically regional data, the 4th sheet a data summary
page.

I unfortunately don't have the code I used with me to show you (it is at
work), but does anybody have any suggestions?

Kindest Regards,

andy m