Excel: Copying and Pasting Sequential Intervals of cells in a Dynamic List

Question

I will begin by describing what I am trying to do. I have a list of emails on one sheet (called Master_Email). I want these emails to be copied (or cut, doesn't really matter) and pasted into multiple other sheets. So for example, emails 1-5 should be copied and pasted to sheet 2 (called Email_List_1), while emails 5-12 pasted to sheet 3 (Email_List_2) etc. etc.. However, I will be using a formula to calculate how many cells should be pasted into each of the Email_List_1 and Email_List_2 (it will just be total/X, where X is a number that I choose and total is the total money). The master list will be dynamic in nature (I already have a macro for that), and so, the Email_List_1 and Email_List_2 should also be dynamic in nature.

For example: After running my macro, I would attain this Master_List . After the calculation is done, cells 1-10 would be sent to Email_List_1 and cells 11-28 would be sent to Email_List_2. However, if I run the Master_List macro again, then I would get a different amount of emails and a different set of emails. Rather than having to manually select and paste these cells, I would like to do it automatically if that is possible.

I really don't know where to start. Please let me know if any additional information is required. Thanks.