It's not clear to me what the problem/confusion is. Maybe you could provide more details.
Each time you click the "Find" button, it searches for the next occurrence of the text and highlights it. When you have "Search all Sketch Tabs" ticked, this will be done across all the tabs of the sketch. The current tab is highlighted in white and the others are in teal.