Duplicate Row and Rename If Column Contains Value

[migos]

Hi I need help for a fairly simple issue, but am very inexperienced with VBA. I'm currently assisting my team with tracking sales activities, however the log is updated manually and the sales activities are sometimes performed by more than one sales person. As you can see in the attached the Sales Person (Column B) will occasionally have a "/" to define the multiple persons involved. The entry would all be completed via Data Validation, however I would like to keep the solution dynamic as in the future different combinations would arise (i.e. sales activity by "Chris/Jeff"etc.). Essentially I am looking for a simple VBA macro that would first duplicate the whole sheet, and then find which rows in column B contained "/" and duplicate the row directly beneath for as many "/" as there are. For example if the Sales Person column had "Jeff/Brian/Chris", the macro would copy and paste the whole row twice below that line, and rename column B in order of the names presented (i.e. the copied line would change column B from "Jeff/Brian/Chris" to "Jeff", the first copied row below column B "Brian", and second copied line column B would be "Chris").

Thank you in advance!