I need to refer to the current sheet's name in the sheet itself. Any
way to do this?

There are proposals for adding this to the CELL function, but it has
not been implemented. Writing a custom function for it would be
trivial. Have a look in gnumeric/plugins/fn-info/functions.c there
is some vba in a comment.