rename sheet automatically
 

What i mean is I write the name of the person in cell a14 and i want to
press a command button to change the name of the sheet to this name in the
cell and then copy to a workbook i have setup in another directory.

I am not sure how private subs work

Sorry to be so unsure of the help so
far

Tami