Is there a way to automatically update cell references in a linked workbook?

Yes, Excel has a feature to automatically update links to other workbooks. Go to the 'Data' tab, then 'Refresh Links'. This will update the cell references in the current workbook to match the changes in the linked workbook. You can also set up automatic refreshing of links through Excel options.