How do I pull information from a list of cars sold to a different page for each salesman

[RyanVB99]

I am making a pay plan spreadsheet for a car dealership. Each salesperson has their own page, and there is a master page that lists all cars sold. I need to make the sheet so that when someone enters a car sale and who sold it on the main page, the information is copied into the page of the salesperson responsible for the sale. I have attached a rudimentary copy of the sheet itself. In the images I am trying to get the information in the blue box copied to the green box, based on the recorded name of the salesperson (I know there are a bunch of issues like not having enough columns, right now I am just trying to figure out how to move the information automatically). Thanks in advance for the help.

[mikeava]

You were on the right track. On your Dennis tab, change the 3 in your formula to 5 and it will populate the name.

=VLOOKUP($E$2,TestNewLog!$A$7:$K$14,5,FALSE)

[RyanVB99]

You were on the right track. On your Dennis tab, change the 3 in your formula to 5 and it will populate the name.

=VLOOKUP($E$2,TestNewLog!$A$7:$K$14,5,FALSE)

Right, I know the index and some other things will change, my main thing is that I'm not sure how to make pull several rows of information. When the information is input into the master list, it won't he sorted by salesperson, so I'm not sure how to cleanly exteact that information. In the image we habe a var sold be Dennis, and then several other people, if I just had a vlookup (like the one I showed) for every cell, there would be gaps between each person (hopefully that makes sense, Ill get pictures posted as soon as possible)

[JeteMc]

If I understand paste the following into cell B7 (Dennis sheet):

Please Login or Register  to view this content.

Once the formula has been pasted then drag the fill handle down to cell B30 and then while B7:B30 are still selected drag the fill handle over to cell E30.
Let us know if you have any questions.