The Sheets Pages Manager add-on is a quick and easy method of managing Google spreadsheets which contain several pages. It will allow you to list, in a spreadsheet, details of all the pages in that spreadsheet. You can check how many cells are in your spreadsheet to make sure that you don't hit the 5,000,000 million cell limit.
With it you can manage all the pages in the spreadsheet at once, you can:
Protect and un-protect pages
Hide and show pages
Make copies of pages
Delete pages
re-order pages
re-name pages
clear the content and/or formatting of pages
trim empty columns and rows
Installing and using Sheets Pages Manager