Is there a worksheet function that returns the name of the sheet the cell is
on? (Much like the way ROW() and COLUMN() return the cell's position)

=ROW()
=COLUMN()
=SHEETNAME()

the ADDRESS function I thought would work but it only accepts a literal
string that is then appended to the address generated by ROW and COLUMN.

=ADDRESS(ROW(),COLUMN(),,,"Sheet1")

I need this:

=ADDRESS(ROW(),COLUMN(),,,???YouTellMe)

TIA
Charlie