Dear Experts

Need help with the following scenario.

1] I' am having an Excel file with 5 Sheets.

2] All Sheets are having some Data Validations as well as few Formulas and some restrictions with VBA Code.

3] I' am allowing user to insert Sheets as they required for some other information process [hence can't disable sheet addition]

PROBLEM STARTS HERE

4] As my file contains 5 sheets i.e. A, B, C, D & E. all having Codes & Data Validation

5] User Inserts New 5 Sheets, Copied existing 5 Sheets format in the New Sheets

6] Deleted existing Sheets & Rename the New Sheets as Old 5 Sheets.

7] The sheets which are newly inserted are not having any Codes,

8] User can do anything in those sheets without any Codes and restrictions.

HOW TO AVOID THIS?

Any help will be appreciated