there is an add-ins I created that may help you but I am selling it. That was a big issue for me taking screenshots from each different page, time consuming I mean. If it's incompatible with the Excel version you're using, or if you're encountering errors, I'll resolve them specifically for you. I think this will be a helpful resource for those who find coding and working with macros challenging.
Demo Video ----> https://streamable.com/5z5gxd
I look forward to hearing from you, have a nice day