We have received a number of emails asking us how to share a single tab of a Google Sheet without sharing the rest of it. As simple as it sounds, Google does not have a direct way to do this. That does not mean it is not possible to do–you just need to get creative.
Sometimes you want to share one tab of a spreadsheet while keeping the other tabs private. Protecting the cells prevents collaborators from editing particular tabs but they can still view the contents, so it is not a valid solution. The ImportRange function in Google Sheets allows you to create a dynamic copy of particular tabs in a spreadsheet that you can share without worrying about collaborators viewing information in the other tabs.