I have to name different sheets by copying from several cells, say within a column. Each sheet will be named after the content of a single cell. Is there a way to do that?
Try a seach here for sheet name from cell or see the solutions, using a macro, given in the Apache OpenOffice forum
If this answer helped you, please accept it by clicking the check mark 
to the left and, karma permitting, upvote it. That will help other people with the same question.