Does a tab exist or doesn't it?

I am simply trying to determine if a name of a tab exists or not, but I am trying to do in a formula. What I need is like this.

If TABNAME 0218 exists then value = '0218'!A2 otherwise leave it blank.

This is what I have, but it doesn't work properly.

=IF(ISERROR('0218'!A2),"",'0218'!A2)

The problems with this is, it works fine if the tab exists, it works fine if the tab doesn't exist, but it doesn't work if you just create the tab or if you just delete the tab.

Just creating Tab - I have to refresh the formula by hitting F2 then Enter
Deleting the tab - Changes the formula to ..

=IF(ISERROR(#REF!A2),"",#REF!A2)

All I really want is to check if the tab name exists and if so put its content of cell A2.

Is this possible to do in formula?

Thanks,
RJ

You were quite close in your approach, but obviously Excel itself does some updating of references and formulae when sheets are deleted and your existing formula fails.

Try the following modification....

=IF(ISERROR(INDIRECT("'0218'!A2",TRUE)),"",INDIRECT("'0218'!A2",TRUE))