Ok, So I've had a chance to play around with the worksheet you sent, and it is pretty awesome.

I showed it to my husband who has more scripting knowledge than me (not hard really) And he showed me how to change the script to make it so that Column A is the one where I can put the drop down menues and then showed me how to make the new drop down menues, but we seem to be having an issue when we change the specific item. It doesn't delete from the sheet the info was sent to. I have tried re downloading the workbook but I seem to be having the same issue, even if I don't change anything, the information just stays on the sheet after I've changed the information on the raw data page.

Is there something we can put into the code page to get the information deleted from the sheet if the drop down menue changes? Is it something I've done when I changed the script from Column I to Column A? ( I know I said I didn't need to understand earlier but apparently my interest has been peaked)