Automated copying & pasting from multiple sources

[Averil Pretty]

Hi all,

If I have a spreadsheet, can I set up a function / macro
that will search for say "order number" and if it finds it
then copy certain cells in that row and paste them to
other cells within another spreadsheet that also contains
a cell for the "order number"?

I'm not sure if I am explaining myself correctly here... I
can generate a report (spreadsheet 1) that has some
information on it that I need to copy over to another
spreadsheet (spreadsheet 2). From this other spreadsheet
(2), other data is manually entered in. Once this other
data is entered, I then need to be able to use just some
of the data in this spreadsheet (2) to be copied into
another spreadsheet (spreadsheet 3).

Also, if possible when data is bought from spreadsheet 2
to spreadsheet 3 I would like spreadsheet 3 to insert a
new row to contain the information from spreadsheet 2.

I appreciate any feedback.

Thanks,
Averil