help with apps script

RMAG news

I am trying to learn java script for google apps script to have a spreadsheet I can use for theater costume plots. Basically, I want the spreadsheet to generate sheets for different sorts, but then keep them updated with edits to the parent. I have an on Edit script to make a new sheet when an actor’s name is entered, but I can’t get it to link to the new sheet. It also does not sync with changes.