I need for my macro to take the names of employees in sheet 1 (2014) and move them to the corresponding tabs. ie - Hope has 2 customers. I want the line(s) with Hope's customer info moved to Hope's tab. I included highlighting if the name doesn't exist but the problem is the whole A column is highlighting and nothing is pasting into the other tabs. I'm attaching my doc below. Thank you for any help you can provide.
Bookmarks