Dec 17 2020 07:44 AM
Dec 17 2020 01:52 PM
Could we first ask you what is going to happen next? Asked another way, what is the bigger picture here? What's the overall project of which this is just a small part?
The reason for asking: it may well be that you're trying to something that is unnecessary in the first place. It may be that Excel (which has remarkable abilities to work from a single large database) can do that extracting at a different stage of the bigger project, perhaps producing whatever it is you want to do ultimately --- presumably adding more info to each page, or whatever--
That said, I'm sure a macro or VBA routine could be written to accomplish the task you requested. I'm asking my "design question" just to see if there's a better way to do the bigger job in the first place.