Create a sheet that updates from another sheet then move to another computer

[Martynrbell]

Hi all,
I'm trying to create create a sheet that updates from a table in another worksheet.
I plan to then copy all my files to a coworkers computer.

I have an issue that the linked table is looking for the second work sheet on my computer.

I'm not sure what the terminology is but I need the table to update from a sheet that is always located
currentworksheetdir/update/update.xsxl
Regardless of the computer it's on.

I can draw I diagram if my explanation is rubbish ?

 

[drsarao]

Unfortunately, Excel tends to forget the link sources sometimes especially on moving the files.
You have to reset the links: