Need help pulling salesperson commission information from a central data sheet.

I am trying to simplfy the internal managment reporting at my company and I need a little guidance. My plan is to have one central data sheet that includes all of the information needed to build subsequent worksheet which can be accessed by managment. I am running into problems with the salesperson compensation reports. I would like to be able to pull specific information that is in a row, based on the salesersons name listed in a column. It looks something like this.

NAME------------COMMISSION
john-------------------100
mary-------------------125
jill----------------------75
jack--------------------95
So everytime a deal is made by john, and entered into the data sheet, I would like another workbook to recognize the word "john" from the salesperson column and pull the commision info. I know how to link sheets and workbooks, that's not the problem. I am also familiar with the sumifs function, but that function totals all of the row info for the specific criteria in a column. I just want info in a row specified by the criteria "john" in the salesperson column to be copied and then pasted into a seperate workbook. Is this possible?

Yes indeed.

Checkout the VLOOKUP() function.

Regards

Suppose you have names listed in Column A of this second workbook with entreis starting from Cell A2 (john)..
In B2 use
=vlookup($A2,Sheet1!,$A:$E,column(),false)

Hi,

In that case I'd be inclined to use Data Filter Advance Filter, copy to another location.

@tedrummond

Or wath about, using a imputsheet (as you use now) in combination with a pivot table to count the value's per person.

@cutter.

Thanks for that. The advertising had completely passed me by.

@krish3122.

..and to reinforce cutter's remarks, please note the advice you have been given.