Broken Links

I have 12 workbooks each with 7  worksheets.  I'm trying to summarize all of this information into one summary workbook.  When everything is open, everything is good.  But...once I close the 12 workbooks and then open them up again, all of the links show #REF!

The only thing I can see is that after I close them,, when I open them up the worksheet name seems to be gone from the path.  Below is the pathway before it is opened up again.

='R:\EMPLOYEES\2022\Timesheet Allocation Spreadsheets\Farm Labourers\[Artemio.xlsx]Anderson'!$AB$104

Here is what is looks like after I open it up again

='R:\EMPLOYEES\2022\Timesheet Allocation Spreadsheets\Farm Labourers\[Artemio.xlsx]#REF'!$AB$104

I have no idea what I am doing wrong...but after breaking a couple of thousand links, I'm getting pretty discouranged