D gets blown up in Generations, E makes an entrance in First Contact and is around for the rest of the movies, EU of Enterprise E is still around as far as I read, captained by Picard (who is married to married to Crusher, son Renè), First Officer Worf. Data is running around ultrarich (but wanted by the orion syndicate trying to sort out Lal, but is Lore, but is Data, but is Lore (I'm not spoiling that part anymore than that), Riker & Deanna are married and Riker got his own command, the Titan, with a slipstream drive, i _think_ LaForge is with the Daystrom institute, Wesley actually made himself useful and saved the universe once, the Borg wiped out significant parts of the Federation (we also learned their origins), but they're rebuilding, we learn the truth about section 31, Andor went pretty much sterile but Bashir broke so many laws it's amazing to fix it (small DS9 there, but potentially relevant), several hostile species (Romulans, Tholians, +++) have joined into a typhoon pact, The traditional Romulan Empire doesn't really exist anymore, but it split into (mainly) 2 governments, and lots of stuff I can't remember off the top of my head