I have a workbook with 23 worksheets.

I need the worksheet name to be automatically inserted into a
cell on each worksheet.

Worksheet names are all 5 characters - example is 14-01

I'm using =Right(Cell("Filename"),5)

It works - sort of. But does not automatically calculate. When I
recalculate every worksheet gets the same value (the number of
the active worksheet when I press F9)

Is this just a quirk of Excel, or is there another way to do it?

Thanks for any help.