Thanks for your help! First off, yes, all the data was for demonstrational purposes -- the real problem is on a work file. I wanted to display the metric data (whatever that happens to be) on a separate tab, separate from the raw data.

It's still really weird. Basically, if you take the "Data2!" out of the formulas on the Data2 tab, it works. When I initially created the formulas, the "Data2!" was automatically populated by Excel.

Anyways, it's working and I'll just have to keep a note of this Excel quirk.

I'm sorry I made a typo which might be confusing. My FYI should have said there were unnecessary references to Data2!A2 (for example) in the Data2 sheet. The sheet name doesn't need to be referenced when refering to a cell within the sheet the formula is in... Anyway you know all that.