Generally speaking, you can not change the spreadsheet "native" features, so the answer is no.
You might try a few workarounds as suggested in @Kriggs comment but you probably won't find it very practical.
I suppose you were asking this because some users are messing up your spreadsheets doing unintentional mistakes ? if that's the case then the best approach is probably to create an onOpen function that will "clean up" the document when one opens it, deleting all unnecessary rows and columns and removing empty sheets.
If you need more about how to achieve this please edit your question to add more details.
bonus : demo code
function resetPageLayout() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sh = ss.getSheetByName('Sheet1');
ss.toast('Now processing your sheet','Wait a few seconds',5);
if(sh.getMaxRows()-sh.getLastRow()>0){sh.deleteRows(sh.getLastRow()+1, sh.getMaxRows()-sh.getLastRow())};
if(sh.getMaxColumns()-sh.getLastColumn()>0){sh.deleteColumns(sh.getLastColumn()+1, sh.getMaxColumns()-sh.getLastColumn())};
var sheets = ss.getSheets();
for(var n=0;n<sheets.length;n++){
if(sheets[n].getName()!='Sheet1'){
try{
ss.deleteSheet(sheets[n])}catch(err){
Browser.msgBox('Can\'t delete Sheet named "'+sheets[n].getName()+'" ('+err+')');
}
}
}
SpreadsheetApp.flush();
}
If I understand correctly, you have a single spreadsheet with two sheets, and you want to add a link in a cell in Sheet A that switches the active view to Sheet B.
I believe the function will solve your problem. The HYPERLINK you enter as first parameter to this function should be of the form url where "#gid=<sheet id>" is the sheet id for Sheet B. <sheet id>
You can find the gid for Sheet B by switching to the sheet in the browser window, and look for the term at the end of the URL. All Google Sheet URLs take the form gid=https://docs.google.com/spreadsheets/d/<spreadsheetId>/edit#gid=<sheetId>