hey guys,
i have a worksheet with names in col A and their correspoinding info in subsequent columns (col A has the names, col B has the phone numbers, etc)

what i'd like to do is create another worksheet, and when someone types in a name from worksheet 1, all of their data from the entire row of worksheet 1 will appear in worksheet 2. does that make sense?

if anyone can help i'd very much appreciate it. thanks!!