It is possible, using the worksheet functions, to extract the worksheet name?

If not, is there another way that shows this result automatically without
the need to run a macro?