I ended up using option B which works pretty well. It actually works better this way because now I don't have to import a table from a data connection to use the function I need. I can just host in another worksheet in the same Workbook. I can also use the first worksheet to give instructions to end users that don't know how to run a Macro. I work in a warehouse so this is the case for most users.

The only unrelated but major gripe I have is how Excel uses ColumnWidth. Its not very intuitive at all! I can have 2 workbooks side by side (2 identical monitor setup) and they can have the same margin settings and same pixels for row height and column width but they won't be the same. That will be my next subject to dig into.