I have seen and used code from this list that creates a worksheet with a name
from a specific cell.

What i'm now looking for is a way to create a variable number of sheets to
match the input from users, e.g. one week there will be a list in column A
of 3 items (perhaps 517,518,519) the next week a list of 4 items (possibly
517,519,612,613) and i want a sheet created and named for each of these.

could anyone point me in the right direction?

tia

Hi Tia,
just select cells with names of new sheets and run this:

Sub newsheets()
on error resume next
Dim ns As Worksheet
For Each ncell In Selection
Set ns = Worksheets.Add(after:=Worksheets(Worksheets.Count) )
ns.Name = ncell.Value
Next ncell
End Sub