Why are my sheets not showing when I need to cell link to them?

When I want to select from a data source, some sheets are not showing.

Answers