Sleeper: Macro to find correct workbook from table name in cell

[naomicjones]

Hi, i am fairly new to macros and after some help. I have a work sheet which has multiple tables on each of these tables has an equivalent work book. Is there a macro formula which will look at the table names in the cells and then find the corresponding workbook for which i will run vlookup?

Thanks

NJ