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.