Scalability – one address multiple inputs one signature scheme

I have an idea and would like to know if current or future technology will allow it:

Assume 100 people with index i Each person has a secret Ri The secrets Ri are combined via an abstract mechanism to produce the public root address P0. Everyone can compute address Pi from root address P0 and index i.Assuming a mechanism for aggregating signatures Si

For example, if 100 people spend on business investment addresses, they can only use 1 input address and 1 signature, saving 99 signatures and 99 input addresses.

Is it feasible? How hard would it be to implement in Bitcoin? Can Schnorr Signatures do it?