I have few sites in one of my site. There is a list, with same name say 'SOW' in all of these sites, containing site specific data.
Now, at the parent site i want to see all the data at one place from the 'SOW' list in each of the sub-sites. Below is the representation of what i mean.
A (Root Site) A1(Sub-Site) A2(Sub-site) A2(Sub-site) A2(Sub-site) SOW(List) SOW(List) SOW(List) SOW(List)
Now, at "A (Root Site)" i want to see all the data from 'SOW(List)' of each "A1(Sub-Site)", "A2(Sub-site)", "A2(Sub-site)" and "A2(Sub-site)"
Basically, i want to know whether we have some Out of the Box solution for this scenario. If not, let me know some custom solution.
Thanks in Advance.