I once found a product like this several years ago designed for wss3.0.
However, with the release of moss 2007, new add-ons should be
developed. I try this cross-site lookup for weeks, and it does work.
Those who want to get it can browse this site
http://www.sharepointboost.com/.