Creating a new tracking number with every new page

Thanks for getting back to me.

I have 100 sheet that look all the same but the data information on them are all different. I essentially want a different tracking number on each sheet. Maybe it starts on the first sheet at 1000 and each time I add a sheet it goes to the next number. 1001,1002,1003 and so on. Never repeating itself.

Each sheet has a list of 8 items each with a unique S/N. I want to have a number for each sheet that will link it to the box that has those 8 items in it.

Does that help?

"Maybe it starts on the first sheet at 1000 and each time I add a sheet it goes to the next number. 1001,1002,1003 and so on. "

That's not random. Do you mean "unique"?

In your first post you specify starting at 18000, but then you give an example of 1000. How do you determine what starting number to use?

This can done using the NewSheet event in ThisWorkbook, but I would like to nail down the numbering scheme before putting effort into writing code.

Thanks for your time, I want to start with 18 because it will represent the year. I will have more then 99 sheets in a year, that's how I came up with the three zeros after. The numbers can be consecutive or random it doesn't matter. I'm going to have the sheets locked, that's why I would like it to do it everytime they copy to a new sheet. If it doesn't work that way, maybe a button would be the better way to go. If all else fails.

I have attached a sample of the spread sheet.

Thank you for your response. There isn't anything that needs to be carried over.

I am still hoping someone can help me solve this problem. There is a sample file attached.

I was asked why I started with 18. I used 18 for the year.

Thanks for any assistance