copy rows from different worksheets into one worksheet

[vyvek]

Hi

I am trying to use excel to generate html code. I would like to copy a row from each worksheet onto one worksheet. I have 16 worksheets. Once the first row is copied from each worksheet on different rows in the destination worksheet, i leave a blank row. then i copy the 2nd row from each worksheet and so on till we reach the last row on the first worksheet.

I am attaching a sample of the workbook. Sheet1 is the destination worksheet. I would like to thank everybody in advance for the same.

Cheers
Vivek

[JBeaucaire]

This should do that:

Please Login or Register  to view this content.