Cell - filename

Is there a formula that I can use that will show the current workbook (file) name automatically? Thanks for your help.

Yes.
=MID(CELL("filename",A1),FIND("[",CELL("filename",A1),1)+1,FIND("]",CELL("filename",A1),1)-FIND("[",CELL("filename",A1),1)-1)

This can be found here (and much, much more!):
http://www.mvps.org/dmcritchie/excel/pathname.htm

Hope it helped
Ola Sandström