Hello all! This is my first post, and I'm still a bit of a beginner with Excel, so I thank you ahead of time for your patience.
I have a workbook that has many sheets, and one sheet has formulas hyperlinking to these sheets.
However, there is a chance the sheet names may change.
So my question is, is there a way to have a formula reference a specific sheet even if the name of the sheet changes, without breaking the formula? Like a dynamic reference sort of deal?
Thanks in advanced for your help!
Bookmarks