Weekly Rent Payment sheet - List due dates and tenant based on tenant and duration

Good afternoon, I am creating a sheet for each room that is currently being rented. (I have attached one worksheet as an example).

In the example the new tenant John Doe started a tenancy on the 01/01/23,(A7), rent is due every seven days from this start date.

1) I would like to list the payments dates, (start date (cell E7) +7 days from cell A28 and also tenant name (John Doe in this case) in cell B28, but only until his tenancy ends on 04/05/23 as stated by (cell F7).
2) I would then like the dates in column A to resume when Britney begins her tenancy, from her tenancy start date in (cell E8) and until her end (in cell F8)
3) This repeats for Trevor Jones onwards......

Many thanks.