Updates to line number 1000 and then again from 1 to 1000 again

[littleiitin]

What I understand, you want only last one thousand rows in your main sheet and complete data in Data1 sheet.

Am I Correct?

Thanks
Rahul