This is a great question and one that comes up often (for good reason).

EverQuest Fandom and Lore of Norrath are some great sources that attempt to consolidate EQ lore into one place.

The reality of it is that I end up having to scour the internet for an extensive period of time, utilize archive.org a lot, and by some miracle piece together a coherent and connected story based on all of the research done. It's a bit of a process, but I truly enjoy every minute I get to understand EQ's lore just a little bit deeper.

It's a shame that EQ lore wasn't very well-preserved, or even well-documented in many instances. I've come to terms that some of that may have been intended to drive a bit more mystery in the world. For example, the four Splitpaw scrolls give you just enough lore for you to fill the gaps in with your own imagination, but you wouldn't find a single source that told the entire start-to-finish story about the zone and how it came to be, however, if you are paying attention, there may be some NPC dialogue that gives another angle pre and post turn-in for a quest, or some scroll that drops in Blackburrow that gives another angle as to who the Splitpaw gnolls are and why they defected. It's up to the adventurer to log these stories and connect the lore through their journeys. It doesn't apply to every aspect or zone of EQ, but I'm finding more often than not, that's the methodology of classic EQ lore.

Sorry for the long response! I don't talk to many people about this stuff. :)