Hi
A couple of thoughts...

Although I have very little Excel experience, I would start by creating a page that holds all the auto-fill data and feed all pages from there. Then construct a “work” page where the necessary data is automatically filled and the user inputs whatever else is required.

With respect to the need for increasing rows, it looks like the current layout is essentially multiple tables stacked (vertically). If they were organized horizontally then the need for a varying number if rows can be easily accommodated.

Regards