Thank you for writing all of this, it's incredible. I followed this post and hope you regularly update it. It desperately needs to be stickied permanently at the top of forum. (edit: I guess it's already stickied inside another sticky. Good enough. lol)
I've been trying to get into all the AoS Black Library books, short stories, audio books, and audio dramas through kindle/audible and have made so many dumb and needless purchases. This has really helped me through the maze. The detailed break down of every story and the books in which they appear is invaluable. I only wish I had found it sooner.
The Black Library is so complicated and confusing. Trying to make sense of all of their offerings has made my head spin. Their website is terrible. It's not organized at all. It doesn't even list all of their offerings, unless you know the specific name of some stories and use the site's search bar or google you won't see it. The website doesn't even have a general timeline that shows where everything they sell (or have sold) lands to help people follow the story or know what to read next. It's absurd and very frustrating. Why couldn't GW have a guide like yours? The cynical part of me thinks GW does this on purpose to maximize profits somehow.
Anyways, it would be great if you could add a section that summarizes which books you need to have every AoS story (novel, short story, etc.) with the fewest purchases possible, even if that might mean having books which contain the same short stories or books they no longer sell. I know that's what your posts are doing in essence, there are just a lot of individual stories to keep track of. So a dumbed-down (few details or just book titles) section would be awesome. I guess with warnings of current offerings that are likely to be in future collected works books, because from what I can tell, most books and stories will eventually be put into an omnibus or collected works book anyways. And also, maybe a section doing the same with the audio dramas and books they sell.