I'm a senior software developer with more than 20 years of experience (look at my portfolio for some application developed by me, especially the Real Estate Management one), therefore I'm able to develop every type of application, via code or using Microsoft Office Suite.
Excel macro are written in VBA (visual Basic for Application), I'm a VB developer since many years and I know it very well, so I can tell you it isn't the best choice to achieve your goal, because it is an outdated language limiting the power of modern technologies.
Instead I could develop an application for you, based on Microsoft platform, so you can achieve every features you need, current and future, without limiting any interaction with the external world (automated mail delivery, reporting or exporting data, process automation, etc.).
I can develop a green application, so it don't need installation and can be freely portable on USB drive or shared on every web space (Google drive, One drive, Drop Box, etc.).
A true application is a valid investment for your money, an Excel spreadsheet is valid today, but in the future ?
Remember when Microsoft has changed its file format some years ago, how many document wasn't more able to elaborate data because developed for the old format, a complete waste of money for companies.
If you are interested with my solution, feel free to contact me via Freelancer for more details.
Best Regards