I have a spreadsheet that has evolved over the years with the wonderful help of forum members.

The time has come to add another function which I have seen in a colleagues spreadsheet but unfortunately I can't pick his brains as he has left the company.
Here is what I would like to achieve


1. To create a "delete all" function on the front page to clear the data in that row except for cells J5,M5 & AA5. this function would also have to clear the data in the white cells in the linked sheet (cell AA5)

2. To have a "Do you really want to do this?" pop up to complete the Delete All function

3. I plan to add an additional duplicate 17 sheets to this workbook therefore adding the same functionality to rows 6 to 10, 12 to 17 and 19 to 24

attached is a blank copy of the work book, It has Macros that will no doubt require enabling

I class my self as a slightly knowledgable excel user but would appreciate guidance on how to copy the functionality to the other rows in part 3 of my request

Langworth PSAG 2023 ver 3.xlsm