I am afraid that the described scenario cannot be achieved with the current implementation of the control as RadSpreadsheet can work with only one data provider
at a time. Optionally, you can load different providers on Page_Load, depending on the needed data (as they are not persisted).
You can also consider the implementation of a custom DataBase data provider
, where you can define a template-like structure in the GetSheets() method. A sample provider implemented by us is available here:
Telerik by Progress