I realize no one can help me with the eye twitching issue...

But I'm hoping there is a workaround-the-twitch-causing-user-issue. (Key issue I need help with is in bold at the bottom... the rest of this post is superfluous)

So I have a workbook. It links to 30 other workbooks and summarizes how much is left in the various budgets. Each of those workbooks contain a dozen-ish sheets.

I know that if I keep the Summary workbook open and the Random Budget workbook open... if I change the name of a tab, it updates automatically.

But when I have 300ish other users entering information on 360(ish) worksheets... a certain percentage of them seem to feel the need to change the name of the tabs.

Assuming that changing human behavior is not likely: What can I do about my Summary workbook? I get #REF errors every time they decide to change something. (Are they supposed to? No. But that doesn't seem to stop them.)

Since the whole point of my Summary workbook is to not open 30ish other workbooks, constantly having to go fix the links is anti-efficient.

So I guess I'm looking for some way to retrieve the names of all the worksheets in each workbook... even if those names change. From there I can figure out how to mash together the references to those sheets.

I realize if the workbooks were protected it would help. But lets just say, logical or not, I cannot convince the powers-that-be that this is a good idea. (Also, I posted this on Mr.Excel before I remembered that the only good help I've ever had was from this website)