Good afternoon!

I have two workbooks that I need to link: Workbook A (which is the main workbook), and Workbook B. Workbook B has four huge tables that I only reference some of the time, and I decided it would be best to move these tables out of the main workbook to speed things up. I am having trouble in two areas:

First, I want to cross reference the tables in B using INDEX/MATCH, but I am unsure what the syntax or verbiage is for referencing the whole table (not just a colum). I want this formula to be dynamic (hence referencing the table instead of the cell ranges), so that when B needs to be updated, it won't affect the formulas in A.

Second, when the main workbook is done it will be used by several other people on their laptops. I need a generic way to list the file path of Workbook B so that it can be used by anyone on any computer. Communication between these workbooks is one-way only, and the two workbooks will be saved together, so I was thinking of having the file path for Workbook B reference the file path for Workbook A. Is this possible?

I hope I have been clear enough, but if clarification is needed just ask!

Thank you!