OutsideObserver <Stand And
wrote...
....
I should also be able to concatenate a hyperlink as well. Can I do
that? If so, I would be able to construct the hyperlink which I
currently copy then edit, from sheet to sheet, so it would work
regardless of which sheet I put it on.

If you use the HYPERLINK function, it's arguments can be any valid
string-valued expressions.

I also find no facility to construct a string using the sheet name.

Meaning, e.g., you want a formula that returns the name of the cell's
containing worksheet? IOW, a formula entered in some cell in a
worksheet named FOOBAR that would return FOOBAR? That's something
Excel does do poorly. If the workbook has been saved, I find it most
efficient to define the name WSN referrring to the formula

=MID(CELL("Filename",!$1:$65536),FIND("]",CELL("Filename",!$1:$65536))
+1,32)

If the workbook hasn't been saved, VBA is the better option.