Objective is to copy say row 6 on multiple worksheets and paste each copied
row onto a series of successive rows on another worksheet.

I have been able to do this with lotus spreadsheets but cannot find a way to
do it in excel