Auto Insert row to specific range

I have a workbook in which I run a macro whose job is to clean up.
the macro deletes a column with information and then cut and paste the other information so everything moves forward and the last column is clean.
everything runs as it should until someone deletes a row.
I now want to add a row but using the macro. In other words, the rows must be fixed for the macro to work.

Please Help me, this is the code.

Please Login or Register  to view this content.

it's a loop that needs one more feature.

good advice, but I think I was a bit confusing macro extends over 12 sheets

This is the full code I use and it works fine until someone deletes a row with out adding a new I'm sorry I can not upload the file if I do that it is seen as leaking information.
Hope you understand.

Please Login or Register  to view this content.

dident work, it failed were the red text are.

Please Login or Register  to view this content.