Tabs Titles to incorporate into worksheet

Patrick2788 This formula inserts the ACTIVE sheet name.  So if I have sheets "List1" and "List2" and I type that formula into cell C17 in "List1" it will return List1.  But if I go to sheet "List2" and do some work, it changes cell C17 in "List1" to List2, because "List2" is now the Active Sheet.  I have 10 sheets and I put that formula in each one of them - and each one changes whenever I go to any of the other sheets and do anything that makes the worksheet recalculate.  So if I have "List 1" "List2" "List3" etc. up to "List10" and have that formula in cell C17 of each sheet, they ALL show the name of the Active Sheet.  So for example, if I go to "List5" and add a formula in cell D53, then C17 in ALL TEN of the sheets change to List5.

I want a LIST of all 10 of the sheet names on another of my sheets, (which will reference to the sheet name in each of the "List" sheets) but if I do some work in "List4" then my list becomes:

List4

List4

List4

etc. - instead of what I want, which is:

List1

List2

List3

etc.

I need something that keeps the sheet name for THAT sheet, not the sheet name for the Active Sheet.  And I need my list to change when I change any of the sheet names.

Any ideas?

Thanks!