Copying User Input from One Worksheet to Another

[jadown]

Hello All,

I'm trying to code to automatically copy the user input from one sheet to another sheet. Three of the options the user has to choose from contains a list. So if the user selects A,B, or C then the code would copy the lists to the Optional tab and then the code would just loop through the Main worksheet and copy whatever the user inputs to the next available cell in the Optional cell.

I hope this makes sense. I attached the excel file.