Display the sheet name in a concatenate formula

Hey ya'll,
I'm pretty sure this is either an easy one or impossible one:
I have multiple concatenate formulas to populate cells on multiple sheets. Right now, they're multiple different formulas, because I can't find a way to have Excel read and insert the sheet/tab name into my formula.
Now, I know that you can use "&[TAB]" in the header/footer and it'll do just that, but when I tried that in my formula, it didn't work.
So far, I've manually typed the tab name into the formula, but with each engineering change, I have to change the name and manually re-type the formula (or at least change it). Thus-far, my formula is simple:

Please Login or Register  to view this content.

My question is this - is there a way I could replace Sheet 1 Named thus in my formula with an auto-read of the tab name?

Please and Thank You in advance.

Try
=CONCATENATE(Printout!$H$4," ", MID(CELL("filename",A1),FIND("]",CELL("filename",A1))+1,50),
" Named thus")

Exact! Thank you!