Mike,
Thanks. I tried that - however - - - it only kinda worked... Here's whats
happening...
I have 8 tabs in this workbook. I entered this formula separately on to
each worksheet - but regardless of which worksheet I placed it on the same
result appears on each... for example, text from tab one appears on all other
worksheets.

"Mike H" wrote:

Hi,

Try this

=MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)

The workbook must be saved for it to work.

Mike

"klee" wrote:

I have a multi-tabbed workbook. I would like to link a cell to the text
entered on the worksheet tab... I've seen it done before - but don't know how
they were able to do that... Can someone fill me in?

Thanks!