Updating data lists via outside table source

Is it possible to use Tables from another Excel spreadsheet that can automatically updated dropdown data lists on a worksheet?

We use a timesheet with tables. We all make a "save as" copy of that timesheet weekly. However, if something changes on the Table, it would have to be changed on each timesheet.

If we had a Table that was located on a server, and a way to direct the "datalists" to that table, we wouldn't need to update each timesheet.

Can anyone let me know if this is possible? and how? It needs to be simple with what we have already in place.
Thanks