Auto Date and Value Rotation

Hi Everyone,

I am running a small reading club for people in my area where the book has 48 chapters and 24 members and each member is given a roll No which is fixed.

I have created a small excel sheet which has all the chapters mentioned according to the Roll No's. Everyday I do prepare the sheet manually due to which sometimes error can happen and it becomes tough if they are noticed by the moderators in the evening when the group has to be closed.

I am looking for a way in excel to put the date automatically of one day ahead and the chapters list to be rotated on its own without doing copy and paste sort of work.

I have attached a file for sample.

In the file Roll No 1 will be reading Chapter 1&2 tomorrow, so the excel file should automatically create the next date of 24th May, 2021 and Roll No 1 to read chapters 3,4.

I hope this makes sense