Hi I've read threads from 2017 explaining this isn't really possible - but wondered if things have moved on? Basically as a team we have a large spreadsheet with multiple tabs - one of which we want to the wider org to have access to (restricted, no editing). It just needs to auto update when we update the main spreadsheet.
We used to use google docs and this was simple, via a formula. I can't seem to make it work with SharePoint though.