Personally, I would try using your Master Overview as "database" and create the template in Word.
It should not be too complicated using Mail Merge to extract the information.
Have a look at our Word forum and the Mail merge section to get a first idea about what can be achieved and if it suits your needs.
If you want t go that way, Macropod and the MSWord "gurus" will be of great help.

BTW in Excel you should always avoid using merged cells. They are nothing but trouble. For formatting purposes, " center across selection" is much better

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post