Setting Repeating Pages In A Worksheet?

I need to prepare count sheets for stock take on my company and I have a long list for data with hundreds of locations. What my colleagues have been doing is to filter the locations 1 by 1 and clicking print because we want the page numbering to be 'page 1 of 3', page 2 of 3 etc. for each location.

For example

Location a has 2 pages we want it to be page 1 of 2, page 2 of 2

Location b has 1 page we want it to be page 1 of 1

This is so that we can detect if any count sheets have gone missing.

I want to be able to print everything at 1 go, without filtering the locations manually and clicking print as it takes hours to do so.

Is there anyway I can do it? I have some knowledge on excel but not macros.