Moving Rows to new Tab based on many possible Cell Values

I work as a manager and I'm trying to create an Excel Sheet With a VB Macro that will Check all the Numbers in Column "N" on the "Master Sheet" Tab and will cut the Row they are in and past them to the supervisors Tab there are 127 different Numbers and 6 Supervisors that are in charger of each of them IE 11116 is Mikes Employee, and 11117 is Johns Employee, there are many questions like this but I haven't seen one that answered this for me, thanks in advanced.

Example.JPG

hi mmanning, can you post a sample workbook with data and expected output sample

Sure can, I should have an example ready today sometime, thanks for your time.

Distributer.xlsm

This is what is would look like before the Macro is Ran (for the most part)
post macro to come.

This is what it would look like after, after looking at this I feel its important to mention I can make another Tab called "Reference" or something that has The Supervisors in Column A and their Employees in Column B, also there is some overlapping notice 16389 is on Robert and Kalvin's List there are two employees affiliated with that number so it needs to be on both lists, hope this helps you, help me.Distributer.xlsm

hi there, thanks for the sample file. Yes, it is good idea to create sort of reference sheet to check which number corresponds to a particular name. As far as I see some names have more then 2 ids. As soon as you provide a reference table for that I would help with the code

Here is what I have, I would like the ability to add Driver Numbers to this list when Hired, Thanks again.

Distributer(2).xlsm

please check attachment, press Run button or run code "test" (ALT+F8, select "test", press Run button)

That worked perfectly thank you so much!