Question

how does the data get refreshed betwéen linked workbooks when the destination workbook are closed​

Answer 1

Explanation:

This way if you change the data in the original worksheet, the data in the linked worksheet will also change. ... The workbook that contains the formula is called the "dependent" workbook and the workbooks that contains the data being referenced is the "source" workbook.

Answer 2

Answer:

When you open a workbook that contains one or more links to other workbooks you will be prompted and asked if you want to update those links. You will only be prompted if one or more of the source workbooks is closed, if they are all open, then the links will be updated automatically.