Tips on how to select a number from a column and paste all c

[Mopacs]

Hello,

I am looking for a means to reference a number from a column containing a series of numbers (which changes each time), go through this list, have it find the corresponding number on another sheet containing multiple rows. From there I would like it to copy the corresponding row of data based on the first cell (column A) and then paste it into another (blank) sheet.

I want to continue this until it has reached the end of the list of numbers (from the first worksheet mentioned).

I know this sounds a little winded..but does anyone have some tips?

THanks,

Rob