Hi there --

In a formula in one workbook, I am referencing a cell in a specific sheet in
another workbook. I have changed the name of the tab to TCh from Sheet3.
Because the tab name could change at any time, I would rather use Sheet3 in
my formula rather than TCh. It's not working for me though. My current
formula is:

='[Placement Goals -- 2008.xls]TCh'!S$26

Can I change TCh to Sheet3 so that no matter what I call the tab, the
formula works?

Just let me know if so and how.

Thanks so much,

Ellen G