Let's say I have a main site collection with three subsites each having one document library:
- SubSite1 (myDocLib)
- SubSite2 (myDocLib)
- SubSite3 (myDocLib)
I want three subsites for security reasons and different design aspects. I now want to aggregate these three document libraries on the MainSite. All three lists from the subsites have the same layout.
I could use a content query webpart for that, but I can only select "list of type Document Library" - I cannot select "myDocLib from SubSite1, myDocLib from SubSite2, myDocLib from Subsite3". Also the content query webpart does not have the options a normal list has, particularly I need to export the whole aggregated list to Excel (no interactivity, plain export).
What is the best way to do this? Is it somehow possible to create "virtual copies" on the MainSite? In the end all I want is an aggregated view with Excel export ability.