Auto rotation in sequence and auto-mails from Excel

Dear Excel Experts,
I have Excel workbook with 3 worksheets i.e. PC list, PC Confirmers and Mail Format..
Requirement

1. Process Confirmation (PC) listed in Worksheet "PC list" are to be assigned automatically in rotation i.e. Process Confirmation (PC) are to be assigned in sequence to listed PC Confirmers in Worksheet "PC Confirmers" for example in this case, now we have 25 PC Confirmers, so 25 Process Confirmation (PC) in sequence are to be assigned to 25 Process confirmers and then again from 26th Process Confirmation (PC) onwards, same 25 PC Confirmers in sequence are to be allocated and so on in same manner till end of the Process Confirmation (PC) list i.e. in tis case we have 71 No of Process Confirmation (PC). First week is to be defined based on value in cell L2 in worksheet "PC list"; 1st 25 Process Confirmation (PC) to 25 PC Confirmers and 2nd 25 Process Confirmation (PC) to same 25 PC Confirmers and so on till end of the Process Confirmation (PC) list.

2. Auto-mails are to be sent to all the PC Confirmers to whom Process Confirmation (PC) is assigned as per Worksheet "PC List" in given mail format as per Worksheet "Mail Format"

This task we are doing manually every week, which is hectic

I am very grateful if you help me to do this task automatically i.e. auto-assignment and auto-mails.

Attached for details or reference (text and source is also mentioned in Worksheet "Mail Format", Kindly help

Thanks you very much advance.

RavindraK