Found a working solution...
Instead of creating an array I just used and IF/OR statement:
Code:
If SpreadsheetTitle = "Customer" Or SpreadsheetTitle = "customer" Or SpreadsheetTitle = "cust" Or SpreadsheetTitle = "Cust" Or SpreadsheetTitle = "C" Or SpreadsheetTitle = "c" Then
But I am sure this is not the best way to do it but it works exactly like I need it to.
If anyone knows why this isn't the most efficient way or a better way to do this please chime in.