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 10,000,000 million cell limit.
You can manage the sheet's pages in bulk and do the following:
hide or show pages,
protect or un-protect pages,
delete pages,
duplicate pages,
rename pages,
reorder page sequence,
clear data and/or formatting,
remove unwanted rows,
remove unwanted columns
Installing and using Sheets Pages Manager