Searching and retrieving data

Hi All,

I have a worksheet with several hundred rows each with 10 columns with text and numerical data. Please could someone suggest a way to display whole rows of the above data on a different worksheet which are the results of a user defined search (e.g. name and or date).

Many thanks,
Chris