Create Arrays from external workbook and add worksheet table data to the arrays

[Legacy 392984]

I have a workbook that will be my main program. From this workbook I need to do the following in VBA.
1) Reference external workbook (hardcoded location).
2) Create arrays based on the sheet names in this external workbook
3) Populate each array with the table data in each worksheet once the array is created. The tables are named the same as the worksheets.