Adding functionality to drop down menus

Hello,

I was wondering if someone would be able to help me in my effort to generate a form. I have very little experience coding; I can generate drop down lists, but creating functionality based on the input is currently beyond me.

I need three drop-down menus that perform functions based on the input from the user:

First: new client or existing client drop down menu. If the user selects “New”, then I would need only instances of the “New client table” (found under the sheet “Tables”) generated. Conversely, if the user selects “Existing”, then I would only need instances of “Existing client table”. There will not be a case in which I need both types of tables generated, which simplifies things a bit: either all new or all existing.

Second: Number of clients drop down menu: The user will select a number of clients from 1-10 which will determine the number of tables that are generated.

Third: Based on the number of clients, a number of drop-down cells will be generated (ex: if there are 8 clients, 8 drop down menus will be generated). The user will select the client name from the drop-down menu and that name will be filled in the “Client Name” title at the top of the corresponding client table.

I’ve attached a basic workbook here with as far as I could get.

I’d greatly appreciate any input you could give me at all, whether it’s the completed form or hints on where to get started/what this involves.

Thanks!