Inserting different worksheet names in cells of one specific worksheet.

This is likely a very difficult one. I have read many posts regarding putting the name of a worksheet on a cell of the same worksheet, but nothing like I am looking for. Essentially, I am trying to build an index on 1 worksheet that would list the names of the other worksheet I want part of the index. The easiest way would be to type in all the names of the worksheets I want, but anyone can do this.

Has anyone attempted this before?