|I'm a little confused by the wording in your post. I can't tell if you want the Tab name to be placed in a cell or if you want the Tab name to be based on the contents of a cell.|
Here is how both can be done:
To place the name of the tab in a cell, save the workbook first then put this formula in any cell. Do not change the A1 cell reference, just use the formula as is:
To name a tab based on the contents of a cell, you will need a macro. There are various ways to get the macro to run, but here is the basic code:
For shtNum = 1 To Sheets.Count
Sheets(shtNum).Name = Sheets(shtNum).Range("B1")
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.