Modifying list making macro to tie comment cells to proper list name cell. No whole rows.

Macro makes a list of all sheets in a file at first sheet of file. By clicking on sheet name, it moves to picked sheet. When want go back to sheet list, press ctrl+q.
In every new opening of file, it opens at first sheet (with list).

All works (I just wanted into yourself into that), but I need to write comments in showed cells near list cells. Problem occur, when I change order of sheets in file. Comments stay at same position. I need move comment cells along with list cells.
Not whole rows, because I don't know what may I add next in future.

Please try

Help appreciated

Thanks !


3G8DFbd.png


main macro + back with macro:

Please Login or Register  to view this content.

macro for first sheet display on start:

Please Login or Register  to view this content.

Not sure what you mean (I'm excel noob), but this is how I need it, sorry. I was thinking about it longer.

Would be anyone so kind to help me please ? I can't move to next things, until I will have this solved.

I always want make, edit, delete comments in first sheet(Sheet List). But it seems, comments has to be stored somewhere else and called back from that place.
What about to store them in each sheet macros ? Somebody told me to make some Public function(in each sheet ?), which gives back that text into first sheet.
But it would be ineffective to make manually macro for each sheet. Is possible to make overall macro to make automatically other smaller macros ? Also when I add new sheet, that overall macro, would make into new sheet that particular one.

Would be anyone so kind to code it ?