Google Product Forums
Re: How can I set certain cells to be unmodifiable?
Ask a "how-to" question
You can protect each tab separately - click on the black triangle on the tab to bring up the menu.
Perhaps it would help if you could share a spreadsheet with us and let us know exactly what you are trying to achieve, then Yogi and our other experts can take a look for you.