Dynamic Box Creation

I don't even know exactly what to title this question. I have a box which will return values in cells. There is one cell in which the user will select the number of groups. Within each group the user will select the number of positions within that group. I am completely lost. Basically, each time either of these cells changes, a macro will be run that will update the number of groups and/or open positions in the group which is changed. So by default it may start as 1 group with 1 position. But when the user changes it to 2 groups, another group box will appear, and when the user changes the number of positions within any group box, the number of positions will change. It is quite difficult because there may be up to 17 groups and up to 6 positions for any group. What's more, each new position should have a formula in column a and column b that reference cell A4 and B4. This isn't too bad, because I have had it just copy and paste the group box when duplicating to make more groups. But I am having trouble, because I am running the macro on cell change with "TargetCell" command, and each new group will contain a new target cell. Is this to much to ask. I am having a hard time explaining this, so I am attaching a dumbed down version which should help. I have tried several things with iterations, but the attached worksheet has no macros, because I think it may be easier to start from scratch. To whomever can help, I will thank you immensely and have a deep desire in my heart to buy you a beer next time I am in your town.