Copy insert functions? HELP!!!

[jello123]

Hello all,

I have a quicke. i think

I have a workbook with 4 sheets. sheet 1 has all my data. what im trying to do is and tell me please if this is even poss.
I want to do a global search for a specific numberd then automagicaly grab the result ( the whole line. all 6 fields relevant to theat number ) and past the line in the sheet that im working on. example:

search for 123456 search all open sheets. finds 123456 on sheet 2 copys the whole line. name, last, work number, address ect.... and paste it into a new sheet

can this happen?
thanks for the help!

[jello123]

Please...does anybody have a solution for this please...