Multiple Userforms and Multiple Documents

[Aaronjames]

Hi All,

So I have been creating some userform templates to create a document (which is a Request Memo).

I have currently been doing this for each 'request type' and this has been working fine, however I have been toying with the idea of having 1 document that covers all 20 request Types.

I have been able to add several userforms so that Userform1 lists all the options and depending on what is selected will open the other userform for that specific request type.

Is there a way that i can add several documents in to the project so that there are 20 documents, but only one of them will be produced at the end (not more than one document will be created at a time)?

Essentially i am wanting to be able have 20 Userforms (which from a users perspective will look like on interface) and one document produced.

Is there a way to add documents to the project so that depending on what userform is completed it will fill out that docment only, or do i need to prepare 1 huge document (which covers all 20 request types) and then the userforms just delete stuff?

I have attached a quick mock up of the userforms

Thanks in advance