Hello fellow nerds, I would like to know how to type in a persons name on one worksheet and have it automatically fill in information about that person that is saved on another worksheet

EX

Name Phone Available Info
Sam Smith 555-555-5555 Yes *^&%

Just by typing Sam i want all the info to auto fill from the other worksheet cell rows

is this possible?

I understand how to transfer cell information between sheets by using the =sheet1/b1 and =sheet2/b2 method, but I specifically want to type in the information in the cell, and have the following cells autofill with the information down the row.

Thanks in advance!


Rusty