If these rows are all going to the same output worksheet, in the same order they're found on the input worksheet, there is no need (or point) in processing them one at a time; simply specify the range you're interested in, then cut & paste the lot in one go. It's also far more efficient that way.
Perhaps, then, whoever told you to do this should show you how... Besides, if it's a one-time requirement, it would be far quicker to do manually than it would take for anyone to write, test & debug the code - for which access to a workbook containing actual worksheet names & representative data is vital.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]