Automate Row-to-Sheet Copy

I keep a master workbook where one column contains a person / project name. Every time a new entry is added, I want that entire row copied to the worksheet that carries the same name. If the sheet is not there yet, the macro should create it instantly, then drop the row into the first blank line.

Please build a self-contained VBA solution that:

• runs with a single button press or on worksheet change (your choice, just tell me which);
• preserves the row’s original formatting and formulas;
• avoids duplicating a row if it was already sent to the destination sheet;
• works smoothly even when the workbook grows to dozens of destination sheets;
• is compatible with Excel 2016 and later on Windows.

Along with the code, include a brief “how-to” note so I know where to paste the macro and how to activate it. No other formatting changes are required beyond the direct copy described above.