I need to have a column of cells showing the tab name of the sheet where they
are; now the question is, is there any way to do it rather than copy & paste
it?

Thank you.