Include a reference to each sheet:

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

Adrian wrote:

Is there any way to display a worksheet name in a cell (without using macros).

I have tried =MID(CELL("filename"),FIND("]",CELL("filename"))+1,255)
but if I use this on multiple sheets in the same workbook, they all end up
displaying the same name!

--

Dave Peterson