I'm looking for a list of seforim that collect midrashim on the Parsha. In particular, I am looking for a sefer or seforim that can help me see what happens between the lines of the pesukim according to Chazal and the sequence of events. For example, in the beginning of Parshas Vayigash, there is a whole story behind the scenes mentioned in some midrashim. I would love if there was almost like a history book with the sequence of events that includes the pesukim and the "between-the-lines" midrashim.
One of the possibilities is the collection called "The Midrash Says" by Rabbi Rabbi Moshe Weissman.
The blurb on Eichlers writes as follows:
The narrative of the weekly Torah-portion in the perspective of our Sages. Selected and adapted from the Talmud and Midrash. All the volumes in this popular series will not fail to inspire and stimulate the reader while providing vital information on the Parshah.
"The Midrash Says" can be bought via different resellers:
I would take a look at the Otzar Midrashim by Rabbi Yehuda Dovid Eisenstein which describes 200 minor midrashim, and includes the full text of some shorter midrashim, available to buy at all good seforim stores e.g. here
In a similar vein, I would also recommend the Torah Sheleima set by Rabbi Menachem Kasher which is similarly;
An encyclopedia of the Gemara and Midrash, in which all relevant material in the oral law, both published and in manuscript, is collected according to the Scriptural verse to which it applies together with notes, expositions, and supplements. Thirty-three volumes, covering Genesis–Leviticus 24:23 had been published by 1981 (the first volume appeared in 1927)
The multiple volumes are fully available on Hebrewbooks