In the Excel menu choose: DOSE EDITING » View » Navigation
There may be a lot of workbooks opened, and it is difficult for you to focus on which one to navigate to. But with Navigation utility, it is easier to navigate to any opened workbook and also to any certain sheet. Also it shows how many worksheets are hidden within a workbook.
The below image shows how to navigate to a certain worksheet within an opened workbook.
The upper list shows all opened workbooks, and the lower list shows all worksheets with selected workbook, just double click on a worksheet in the list
and it will navigate to it.
There are options to close workbooks in the list, Ascending and Descending sorting.