Formula required for updating name lists in multiple tables

Try this.

Make a separate file to store all your names in a Excel Table (Ctrl+T)

Then on the worksheet which you want to import data to, On the Data Tab > Exiting Connections > Browse For More > Select The File

However there are 2 limitations -

1) I believe this does not work pre 2010 or 2013 (Not Sure) Excel Versions
2) You cannot edit the master list while any of the other files importing the list are open.

However you might want to give it a try..

https://support.office.com/en-us/art...c-0c86ce62b4f5