That's a very different (and very difficult) requirement. How would you identify the rows in worksheet "100" which need to be deleted?
Impossible to write code for that without seeing your workbook, and understanding your workflow better. It's beginning to sound like a rather different project than your initial question, of how to paste onto a next row...