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.

Sub Copier()
Dim x As Integer
x = InputBox("Enter number of times to copy Sheet1")
For numtimes = 1 To x
ActiveWorkbook.Sheets("Sheet").Copy _
After:=ActiveWorkbook.Sheets("Sheet")
Next
ActiveWorkbook.Sheets("AA_Data").Activate
End Sub

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.

Sub RenameTabs()

 For x = 1 To Sheets.Count
 If Worksheets(x).Range("A1").Value <> "" Then
 Sheets(x).Name = Worksheets(x).Range("A1").Value
 End If
 Next
 
 End Sub

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.