There are many scripts available to create Tabbed Contents in wordpress. Some of them are DomTab, Tabifier and idTabs,
Usually, tabbed contents are used in the sidebar to display popular posts, recent comments, tags, categories or archives. I recently came across another tool to create tabbed contents in WordPress using Yahoo Developers Network Tabview.
After reviewing the API and examples, it looks promising and powerful way to to create tabbed contents. I will post an update after giving it a shot.