SharePoint List That Pulls From Other Lists

Question

can someone point me in the direction as to how I would do the following:

I want to create a list, which pulls say (top 3) items from other lists (more than one), and displays them in one consolidated list. Is this possible? If so please point me in the direction as to how I can accomplish this, thanks.

Answer 1

Oliver, As long as all of your lists are in the same site collection, the Content Query Web Part should do what you want (cite). You'll need some expertise in XSLT to keep the top three list items displayed (example). There's a lot that the CQWP doesn't do that would seem common sense, and this is one of them.

Answer 2

If you have MOSS then what you need is the Content Query Web Part.