I apologize, as I am new to VBA.

I have a workbook with 11 sheets. Three of these sheets are named after 3 doctors in the office. "smith, jones, brown"

The other 8 sheets are different employees.

When the employees enter information on their respective sheets, they enter the doctors last name in column G.

If an employee types "smith, jones, or brown" into column G, I would like for that row to automatically copy into the doctors respective sheet. For example, if an employee types "smith" into column G, then that entire row copies in to the "smith" sheet.

I do not want this row to be deleted from the empolyees sheet. I just want it copied to the doctors sheet on the next available row.

Is this possible?

I apologize or my ignorance, and sincerely appreciate any assistance.

Thank you