Amend VBA code to 'undo' previous run results before re-running code

The attached workbook is a 'template' for user to register their equipment details into sheet "AA_Data", In worksheet called "Sheet", is a template "Record Card" which, contains formulas to populate the headers from the data for each row completed in "AA_Data".

Once the user has input their equipment details into "AA_Data", they click the COPY button, which runs below code.

Please Login or Register  to view this content.

This creates the specified number of duplicate copies of "Sheet" tab, and the formulas contained in this will populate the relevant info from the rows in "AA-Data"

They then click on RENAME button, so "Sheet" and all its copies are renamed "Sheet1", "Sheet2", "Sheet3" etc, so they can then be printed off.

Please Login or Register  to view this content.

My issue is how to build into the code for when new rows of data are added to the "AA_Data" sheet. ( or if row is deleted). The COPY code wont re-run as the "Sheet" has been renamed "Sheet1", and so I need to add to code, where if "Sheet" does not exist, delete all sheets from "Sheet2" to last "Sheet??" (can be variable depending on how many rows of data are entered into "AA-Data" sheet) then rename "Sheet1" to "Sheet", so the Copy code can then re-run.

I am new to VBA and am really not sure where to start on this one! Any advice appreciated.

Usually, you can loop through the sheets, and ignore the sheet you don't want to affect,

Please Login or Register  to view this content.

Maybe this will work,

Please Login or Register  to view this content.