Hello sir,
i'm python expert & Desktop Developer, i worked with many companies to change their excel dashboard into full and standalone softwares with higher capabilities and functionalities, excel is restricted in many things, i suggest to make you a software from scratch that include all excel functionalities and also new functionalities that you desire, we can include pdf, web format report generation, we can add emailing, or more complexe things,
software will be the best choice for this kind of processes as it is flexible, easy to use, more featured and and robust against data corruption.
i can show you some of my previous work to have an idea, we can also discuss this project in more details
i'm looking forward to work with you,
cordially