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