Content Query Web part

http://www.heathersolomon.com/blog/articles/customitemstyle.aspx

http://office.microsoft.com/en-us/sharepointdesigner/HA101741341033.aspx

http://www.datasprings.com/Resources/ArticlesInformation/AboutSharePointContentQueryWebPart/tabid/835/language/en-US/Default.aspx

http://sharepointkb.wordpress.com/2008/07/25/sharepoint-content-query-webpart-customizable-powerful-and-invaluable-to-anyone-who-uses-sharepoint/

Alternative of Content Query Web part:

http://www.sharepointblogs.com/erickraus/archive/2007/09/19/content-query-web-part-alternative-for-wss-3-0.aspx