Using a macro to create a macro?

[flaglerdarling]

Hi, all,

I've been able to use all the help previously provided to others to create a bunch of macros that are helping me out with this workbook I'm creating, and I'm hoping that you'll be able to help me with this last part.

I have a table at the top of the page listing my current 6 coachees/reviewees (currently with names from MTV's "Teen Wolf"). I have added a macro that will insert a row at the bottom of the table, along with a sequential ID number, for any new subordinates I get.

Each coachee/reviewee has their own table below the top table, where I will put relevant HR data, their goals for industry credentials, performance goals, etc. I would like to have a button for each person at the top, assigned to a macro which take me to their table below. I have 14 coachee/reviewee tables generated, so the creation of those isn't an issue (if I ever get more than 14 of either, I'll have bigger concerns than creating a new table)

The issue is that I would like to have a button generated if I need to add new coachees/reviewees.

I will need to do this for 2 worksheets total, but as long as I get one of the sheets done, I can rig it to work on the other worksheet. The file is attached.

Please let me know if you have any guidance on how to tackle this problem.

(If you have ideas about managing the size, I'd be happy to make those changes immediately!)