This is what I'd like to do:
The public (even you!) would have view access to a particular Google sheet. It would draw data from another Google sheet, which you DO NOT have any access to. Using formulas I would filter out the non-public data in the public sheet.
My understanding is that
ImportRange will not let you reference a sheet you do not have direct access to, but I am no Google sheets wizard, there may be another way to accomplish my goals.
This seems to be pretty close, still digesting how to implement it: http://stackoverflow.com/a/14558223/2589506
Otherwise, I cannot have this automated, which would be lame.
Thanks for the help!