Assuming that the sections are actual Word sections, created with section breaks, you can replace the "Y" part in "Page X of Y" with a SECTIONPAGES field. You can insert the field via Insert | Quick Parts | Field.

__________________
Stefan Blom
Microsoft Word MVP

Microsoft 365 apps for business
Windows 11 Professional