That one is exactly what i want,

The maximum amount of the worksheet it will be 50
Range will be like D550 (And a version of code if the range is particular like ; D2540: D4560)
I just want to continue in my current sheet (I don't want the new worksheet to be selected).

In the range D550 I will set up data validation so when i put a value in the cell
i want automatically the worksheet to be insert into the workbook.

Thank you once more for helping me to fix that.
Dritan