I have a very large worksheet with alot of information and need some help!

I want to create a seperate sheets which allow the name to be recognized in
the original worksheet and then auto populate the data into the original
worksheet. For example: if I type "Doe, Jane" into worksheet 2, I want it to
recognize "Doe, Jane" where it was previosuly entered in worksheet 1 and then
have all the data copy into worksheet 1. Does this make since or is it even
possible? HELP!
--
Leigh Anne