i'm trying to create this formula:
tow 1: if col A = "text" then take the data in col B and C and paste all 3
into a new worksheet where I already have "text" defined
so....

worksheet 1
col A col B col C
row 1 mike 5 6
row 2 ted 3 4

worksheet 2
ted <formula here <formula here
mike <formula here <formula here

i want regardless of the order in worksheet 1, to find ted from worksheet 1
and fill in the corresponding columns. hope this makes sense.
tia