I checked this out a few years ago, but thought I might post for an updated
answer. I have a few workbooks linked together and would like to know if
there is a way to create an absolute reference between linked tabs
regardless of the name of the tab. As new projects are started, tabs get
renamed, so we have to have all the workbooks open at once to keep the links
active. Maybe there is a way to name the tab to a linked cell, so as a
workbook is opened, it looks at the linked cell name for the tab name first
to keep the links active? It would also have to work around tabs getting
relocated, so references to Sheet1, Sheet2, would probably not work, which
is why I thought a cell reference would work around that issue.

Thanks!