=INDIRECT("'Tracking Sheet'!a4")

So, quotes around the reference. If you omit the space in the sheet name, you don't need the apostrophes, which is easier

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Confused_Euffy" wrote in message
...
|I am trying to use the indirect formula to look at a particular cell on
| another worksheet. My formula is - =INDIRECT('Tracking Sheet'!A4). The
| result i am getting is #REF. I am inserting new rows in the tracking sheet
| but i would like A4 to be the constant.
|
| Hope this makes sense. Can somebody help me please?