Need Help pulling information from one sheet to another sheet

I have a spreadsheet that reflects the names of Sales Reps and Companies that they've done business with. Each month I must send each of the Sales Reps a copy of only "his/her" sales. I was trying to use the vLookup functions so that it can search for a specific Sales Rep and populate only his/her sales information into another tab of the same document. This is done monthly so each month the tab for Sales Reps will be the same and only the data on the initial document page is modified. Is there a VLookup function or a VBA/Macro Code that I can implement that will only pull the information for each Sales Representative into his/her respective Worksheet? I can use the help with this. Attached is a spreadsheet that can give you idea of what I'm trying to do.

TriedVLookup.xlsx