Hello all!! Is there an "if" formula (or any other) that will return an entire row?

For example:
Column A has my salespersons names
Columns B - J have other info

i have my "master list" of all contacts, and then I have a separate sheet for each of my salespeople.

What formula would i use (if it is even possible) to have excel look for "Mike" on the master sheet & then return all the other info next to his name onto "Mike's sheet" each time it sees his name ?

Let me know if i need to explain that more clearly!
Thanks in advance for your time & help!

Jenny