Thanks so much for the replies!

Yes, I used dummy data and was only concerned about the final appearance of it, not the things you mentioned, so I will work on that this evening before I upload to be sure it all checks out.

And I assumed there were much simpler, much faster ways of automating this very tedious process, but I feel like I've gone too far down the path of creating this gargantuan macro to turn back now.