I've looked around here and found this formula for making the sheet name
appear in a cell:
=MID(CELL("Filename",A1),FIND("]",CELL("Filename",A1))+1,255)

I can not get it to work. At all. I want to use it to link sheets to a
summary sheet. If anyone could give me a step-by-step, that would be great.
Thanks.


P.S. What I really want to do is to make a template where every time I copy
one of the template sheets, the new one ends up with sheet name in the
Summary sheet as well as links to different cells in the new sheet. Is it
possible to do?