I have a spreadsheet that contains 6 different worksheets. In the first
worksheet, in the first column, I have the client's last name. In another
column I have the sales representative's name.

In the subsequent worksheets, I would like to link the same salesperson to
the client. Not all of the worksheets contain the same information and all
the worksheets contains lists that I use to sort by.

When I wrote a function, it referenced the cell name rather than the clients
name (contents of the cell). Is there a way to reference the clients name,
link it to the sales person in the subsequent worksheets?