Allow Users To Add In A Loaction For A Pull Down Menu

I want to create a code that will allow my users to add in a loaction for a pull down menu. I have the pull downs and named ranges all set up. I just now need the code which will promp them message boxes for inputs as well as have the macro insert and paste in their inputs enlarging the named ranges.

Allsheets are password protected and the password is "techedit".

the first sheets name is: "DOR" and the seconds sheets name is :Menus (hidden)".

I need the first message box to ask the user "Name of Client?".
I then need the second message box to ask the user: "Name of Platform?".
And finally I need the thrid message box to ask users: "Well names on Platform?"

I then want the macro to go to the sheet named "Menus (hidden)" and insert the platform name (answer from question 2) followed by the names of the wells (answer from question 3), each well being on its own row directly below the platform name, into the named range called "alllocations". this should be inserted into the bottom of the range.

The macro then needs to expand the range of "alllocations" to include the newly inserted rows. It also needs to define a new range for the newly added well names. The name of this range should be the answer to question 2.

once that is done the macro should take the answer to question 1 and insert it into a named range of "clientnames", as well as change the range of "clientnames" to now include the newly added client name.

And finally take the location name and add it a range called "locations", it should also change the range Locations" to now include the newly added location.