Is there any way to display a worksheet name in the cell of another
worksheet. Example: Worksheet names 1, 2, 3, Summary. I want the Names 1,2
and 3 to display in cells on the Summary worksheet. These sheets are all in
the same workbook.

I have seen answer for getting the worksheet name to display in a cell on
the same worksheet but not different worksheet names.