The idea I came up with, was to store data in a custom List in SharePoint, and create a VBA macro that captures Calendar additions automatically, and uploads them straight to the SharePoint List.

In SharePoint, it often helps to know the basics of how things are structured, and what the standard syntax of URLs is.

Show of hands, how many people are tired of explaining to users what a SharePoint Workflow is and how to navigate to the workflows???

Everyone with an intermediate level of knowledge with SharePoint knows that there are 3 ways to create workflows that act on SharePoint lists/libraries. In ascending order of complexity and flexibility they are: OOTB SharePoint workflows, SharePoint designer workflows and custom developed Visual Studio workflows.