Search, copy and paste macro.

Hi, I'm rather new to the whole making macros for excel thing and have got rather stuck on trying to create a macro.

What I am trying to do is create a macro which will search for a word or number which is entered into a dialog box, with the entered word or number I would like for multiple worksheets to be searched and for each instance that the searched item appears the row it is present in to be copied and then finally pasted to a sheet which I will define as "Search" for example.

I hope what I am trying to do comes across clearly enough.

Any help or advice on what I can do will be much appreciated.

Thanks.