So if I understand this correctly I could declare my Array as 
Global Array = Array_Monday_1("Test.xls", "Test1.xls")
And I could set it:
Global Function Declare_Arrays()
Global Array = Array_Monday_1("Test.xls", "Test1.xls")
Global Array = Array_Monday_2("Test", "Test1")
Then to actually call the Array from within the module, I would use:
    Dim varBooks
    Dim varbook
    Dim wb As Excel.Workbook

    varBooks = Array_Monday_1
Do I have a grasp on that?