The workbook needs to be saved first

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


will return the sheet name of the sheet that holds the formula

it can be put in any cell (even A1), the cell reference is needed that's
all, it can be any cell reference


--
Regards,

Peo Sjoblom



"michaelberrier" wrote in message
oups.com...
I've seen 1000 posts on how to base a header on a cell value. I need
to do the opposite. That is to say, if the sheet name is "Dogs", I
need to put that value in a particular cell on a separate sheet. This
can be done with vba or indwelling formula.

Thanks to all.