It is possible to display all tables of a book, meaning more than only visible books, you'll have access to hidden tables which are archived.

Note : it is not possible to display a table which has been deleted. 

Display all the tables

Click on Display all the tables, at the top right corner of your spreadsheet : 

The list of visible tables and hidden ones are displayed.

Note : it is still possible to display the table options from this screen.