Is there a formula that will output the current sheet name in text format
(into a cell)?

I want the same type of &[Tab] functionality used in the custom
headers/footers, but in a cell in the worksheet.