Not directly in XL, but you could do it with a short macro. Let's say your
list in in cells a1:a12 (must start in first row!). With the sheet containing
these values active, run this macro:

'===============
Sub NameSheets()
i = 1
For Each ws In ThisWorkbook.Sheets
ws.Name = ActiveSheet.Cells(i, "A").Value
i = i + 1
Next ws
End Sub
'==============

You can install a macro by opening the VBE (Alt+F11), Insert - Module, paste
the code in. From XL, go to Tools - Macro - Macros.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"hawaiiham2000" wrote:

Is it possible to use an autofill type feature to add and name worksheets in
a series i.e. Jan, Feb, Mar, etc. or 1, 2, 3?

Thanks!