Ok I partly understand. You want a code that looks at a range of cells. If any of these values are changed then you want a worksheet to be added?

If this is true a couple of things need to be identified.

What is the maximum amount of worksheets you want possible in the workbook?
What range do you want to check? Something like A2:A10?
Do you want the new worksheet to be selected after if is created or stay on the orignal worksheet?

Please post back the answers to these questions and I should be able to put something together.