Hi,

Intro cell with data validation I want to have all the sheet names (except the first sheet), but dynamic. I mean if you add or delete a worksheet, I want to see this in cell with data validation.

Example:
I have 10 sheets in my file (Sheet1 to sheet 10) in cell M3 is data validation and there we can choose any piece between 2 and 10. If you add 2 sheets in M3 can choose between sheet 2 and 12.
Conversely if I delete 5 sheets in M3 I wish I could choose between sheet 2 to 5.

How can I do this? Thanks.