I’d like to be able to make a cell into a sheet… like a subsidiary schedule

Not really. I get what you are saying, and with discipline you could emulate depth with sheets. But it would only be by convention and I don’t think many functions worked that way.