I have a bunch of site collections that all have a identical list( status, Title, Date). I am trying to create a master list on my site that grabs the items from each lists and displays them all together with one extra column called ( Owner ) which will say where the item came from (which site it was on). Can anyone point me in the right direction on how to accomplish this? Is this possible with built in features or do i need to build something custom? Anything to get me started woulf be great. I am using share point 2010. thanks.
Edit - the combined list will not need full functionality, all I plan to do id have the title be a link to the item on its own site collection.
There will be something like 5-10 site collections with one list from each site collection. the list is a task list and we want to combine them all and allow sorting and grouping to get a better handle on all of the tasks needed to be done. this will be accessed multiple times a day so i think a custom web part is a good way to handle it. I have started developing a custom visual web part but I am having a hard time accomplishing what i want. Right now i have a standard table where I pull the lists values into, this is good for displaying all task items but it does not allow me to sort or group the items afterwards (unless I am missing something).
Does this further info help?