Excel: faster way to changing Sheet tab name

I want to change the Sheet name according to a column of data pasted to some cells, I will paste the data to Sheet1 A1:A200, Sheet2 will be named "A1" , Sheet3 will be named "A2", and the rest of the sheets will be added and named, How to do this, Thanks for any help

This question generated 26 answers. To proceed to the answers, click here.

This thread is current as of February 25, 2014.

For more resources for Microsoft Excel