How to skip one row?

[BaGRoS]

I have more than 100 sheets. I extract their name by Name Manager where SheetNames=

=REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1)),"")

and put them in a table:

=INDEX(SheetNames,A75)

Now I would like to be able to decide when to add a sheet with the name Conti in the name and when not. I need to skip a row when I have Conti in the name.
I have started something like this:

=IF($N$82=1,IF(ISNUMBER(SEARCH("Conti",INDEX(SheetNames,A75))),1,INDEX(SheetNames,A75)),INDEX(SheetNames,A75))

however, I don't know how to skip a row when there is 1

Some ideas?

 

[BaGRoS]

This is a drop-down menu for choosing the Sheet name.
But now I set the range manually.

 

[Fluff]

If to formula is in N94 use

=N94#

 

[BaGRoS]

WOW.

 

[BaGRoS]

If to formula is in N94 use

=N94#

How do you know such things?!

 

[Fluff]

Mainly from seeing what other people do on here.