Match a cell value and copy entire row to new sheet

[smfar777]

trying to create a commission workbook. my Master sheet has the data and I am trying to match a salesperson "name" in column G...then copy the entire row to a new worksheet for that individual salesperson. the Master sheet will vary in size with several hundred rows depending on the month. and salesperson name may appear in Column G more than once.

we also split commissions between salespeople so I have column I with the salespersons "name" if there is a split...otherwise it's Blank. Would like to match column I and include on same worksheet for that salesperson (so column G and I together).

File attached
Tab1 - table for vlookup info
Tab2 - Master sheet, this will be constantly added to or removing people
Tab3 - Sales report - This is what I would like to have automatically done for each sales person in column G and I
Tab4 - Recruiting report - automated same as sales.

I'm new to macro's and VBA and loosing hair quickly trying to figure this out Any help would be appreciated. Thanks.