Midras Kejadian 46:8: Shemot Rabbah, Bereshit Rabbati, Midrash Tanchuma & Kohelet Rabbah

These are the names [shemot] of the children of Israel who came to Egypt; Jacob and his sons, every man came with his household.⁷This is a paraphrase of Exodus 1:1 and Genesis 46:8. Israel is equated to the host of the heavens. Shemot is stated here and shemot is stated regarding the stars, as it is stated: “He sets a number for the stars and calls them all by name” (Psalms 147:4). The Holy One blessed be He, too, when they descended to Egypt, counted their numbers, how many they were. Because they are analogized to stars, He called them all by name; that is what is written: “These are the names of the children of Israel.”

(Genesis 45:8) "So it was not you who sent me here, but God; and He has made me a father to Pharaoh." I am like a creditor to him, as it is stated (Exodus 22:24), "Do not impose interest upon him." Just as the way of a creditor is to lend to a borrower (Proverbs 22:7), in the book of Rabbi Meir, it is written, "And he has made me a father," as it says, "which the Lord, your God, gives you" (Deuteronomy 15:2). This is a legal judgment derived from the full texts written in the Torah, which emerged from Jerusalem during the Sabbatical year and ascended to Rome, and the scrolls were stored in the synagogue of Asvyros. "And God saw all that He had made, and behold, it was very good" (Genesis 1:31). "For a man and his wife, leather tunics" (Genesis 3:21). "I will descend now and see their outcry" (Genesis 18:21). "The Lord who took me from my father's house and from the land of my birth" (Genesis 24:7). "And he sold his birthright" (Genesis 25:33). "Behold, now, I am old; I do not know the day of my death" (Genesis 27:2). "The fragrance of a field that the Lord has blessed" (Genesis 27:27). "And Oholibamah bore Jeush" (Genesis 36:5). "Eliphaz, the son of Esau" (Genesis 36:10). "These were the sons of Oholibamah, the wife of Esau" (Genesis 36:14). "They arose and went down to Egypt" (Genesis 43:15). "And I buried her there on the way" (Genesis 48:7).And he has made me a father to Pharaoh." And here are the names that came down to Egypt (Genesis 46:8). "So shall you say to the children of Jacob, and tell the children of Israel" (Exodus 19:3). "The children of Israel journeyed from Rameses" (Exodus 12:37). "For it is a sign between Me" (Exodus 31:13). "Five for the planks on one side" (Exodus 26:27). "We have no barricade against it." "And the priest shall take from its blood" (Leviticus 4:34), for if it is a lamb. "And when the zav becomes purified with living water" (Leviticus 15:13). "One lamb of the first year without blemish" (Leviticus 14:10). "All who come to join the ranks must be counted in their census" (Numbers 4:3). "From the first of your dough, you shall give" (Numbers 15:20). "Avenge the vengeance of the children of Israel" (Numbers 31:2). "And they came to Moses and to the congregation of the children of Israel" (Numbers 12:1). "The heads of the families of the house of Joseph approached" (Numbers 36:1). "But I have not the power to go up" (Deuteronomy 1:26). "And they shall inherit it, they and all the people of the land" (Numbers 32:22). "To give us into the hands of the Amorites" (Deuteronomy 1:27). "Nor take a mother upon her young" (Deuteronomy 22:6). "Brimstone and salt burning" (Deuteronomy 29:22). "Like the upheaval of Sodom and Gomorrah" (Deuteronomy 29:22). "I said, I would scatter them" (Deuteronomy 32:26). So they are written in the Torah that emerged from Jerusalem.

These are the accounts of the Tabernacle. It is written elsewhere: Now these are the names of the sons of Israel (Gen. 46:8). Observe how very precious the Tabernacle was to the Holy One, blessed be He, that He left the upper sphere to dwell in the Tabernacle. R. Simeon held that He dwelt in the lower sphere (at first), as is said: And they heard the voice of the Lord God walking in the garden (ibid. 3:8), but that after Adam sinned He ascended from earth to heaven. When Cain arose and killed his brother, He ascended from the first firmament to the second; when the generation of Enoch angered Him, He ascended from the second to the third; when the generation of the flood perverted His teaching, He ascended from the third to the fourth; when the generation of the separation (i.e., the Tower of Babel) became arrogant, He went from the fourth to the fifth sphere; when the Sodomites behaved immorally, He went from the fifth to the sixth; and when Amraphel and his companions appeared, He ascended from the sixth to the seventh. However, after Abraham came and performed good deeds, the Shekhinah descended from the seventh to the sixth firmament; after Isaac He went from the sixth to the fifth; after Jacob from the fifth to the fourth; after Levi, his son, from the fourth to the third; after Kohath the son of Levi, from the third to the second; after Amram from the second to the first; and on the day that Moses erected the Tabernacle: The glory of the Lord filled the Tabernacle (Exod. 40:34). Scripture states: For the upright shall dwell in the land (Prov. 2:21). This should be read: “They caused the Shekhinah to dwell in the land.”