Active cell showing sheet.

I recently asked for help and I got a swift response (thanks Ada).

The code below is what I wanted.

=IF(ISTEXT(Sheet2!A1),Sheet2!A1,IF(ISTEXT(Sheet3!A1),Sheet3!A1,""))

I'm now wondering if there is a way that on another cell it will tell me what Sheet is active.

So if sheet2 Cell A1 has text then the code above will show what's in that cell. But I want to show in another cell that Sheet2 is the active sheet.

Is this possible.

Mike.