Macro to search Colums for text and display rows containing search

Hello Guys. This is URGENT!
Im at a dead end.
This is what i have to do, I have my main spreadsheet 'data' which i would like search. For instance, a user inputs a product model number into field 'A1'. The Macro then searches the 'Product Number' Column in the sheet 'data' with the contents of cell 'A1' and copies all the rows of data containing the product number just searched for and pastes it on another sheet called 'data2'.

This is a very difficult problem, but i hope atleast someone here can help me. This would be far easier in access, but its too late now, im wayyyy ahead in this.

:thanx: in advance!
Markie!