How can i assign a macro to select a particular Cell (which contains
a name) - which, when a "save" button on the sheet is selected, will save a
copy of that page under a different name - so that the original remains
un-affected.
I need this for a web input page
naturally i don't want the input page altered, but i want the input data
stored.

I have created this page using an excel web form.

Regards