My concerns are 1; it only addresses one sheet and not the ten that OP has
indicated and 2; it rather mutilates the data. My philosophy is to
manipulate data on a separate sheet so that new data can be pasted into the
old data sheet.

I suspect that a complete solution would be needed rather than detailed
support on specific issues in this case.

Tom