Macro to create sheet, rename sheet, and hyperlink to it

Hi Sarah. Try the attached file. I have added a column (AR) at the far right with a dropdown menu for you to choose "Done" when you are finished entering all the data for a particular person. When you choose "done" and then exit the cell, a new sheet will be added with the appropriate name and the balance will be copied over. Hopefully, this will work for you.