Automating transfer of seledted data from one sheet to another in excel 2003

I have many rows of data in sheet 2 of the workbook which is made up of 4 columns of text and numerical data.
What I would like is for the operator to select a record using a drop-down menu in a cell and all of the data appertaing to that record be copied onto sheet 1, is this possible?