Intresting topic
I was looking into doing something on the same lines but with excel (create new spreadsheet based on grouping).
I have created reports which can create different tabs in the excel when exported but havent created anything which creates different speadsheets based on the grouping.
I havent tried it but i shall keep an close eye at your post.
hope to find an answer