So, after a lot of frustration and research I wrote a blog post: Automating Microsoft Excel.
It might save people time. Tweaks, obviously, welcome.
And the code mentioned therein is “In Production” and saving me time and even more frustration.
Honourable mentions to Keyboard Maestro and Metagrid (and Stream Deck).