I dont know if this is possible.

Basically, I keep track of test cases using Excel. I have multiple
sheets that have the same exact test case names (for alpha, beta, etc).

The problem is that if I add a new test case to one sheet, I have to add
it to all sheets. This is painful. What I would like is for the other
sheets to update automagically.

Is this possible? In other words, I am adding test case Z to sheet 1.
Can test case Z now show up on sheets 2, 3, 4, and 5?

Thanks.

-dmp