After years of frustration of SQL Server Management Studio document navigation, I decided to create something to ease my pain and suffering.

Here is a SQL Server Management Studio 2008 Add-in for browsing currently active documents.
Active File Explorer for SQL Server Management Studio