Nobody is in heaven or hell yet! I believe the dead are asleep. Paul may have said: to be absent from the body is to be present with the Lord. OK, to close your eyes at night: presto - it is morning. It is the same principal.
Nobody is in heaven yet: John 3:13: "And no man hath ascended up to heaven, but he that came down from heaven, even the Son of man which is in heaven." They are asleep.
Acts 2:29: "Men and brethren, let me freely speak unto you of the patriarch David, that he is both dead and buried, and his sepulchre is with us unto this day."
Acts 2:34, 35: "For David is not ascended into the heavens: but he saith himself, The LORD said unto my Lord, Sit thou on my right hand, Until I make thy foes thy footstool."
All the OT patriarchs are mentioned in Heb.11 and none of them have received their reward yet. Heb. 12 is just a reference to Mount Zion which is new Jerusalem, yet future. Heb. 11:40: "God having provided some better thing for us, that they without us should not be made perfect." New Jerusalem is being prepared and is coming to earth with the "many mansions" that the Father is preparing.
Be aware that Sheol and Hades simply refers to the grave. Our doctrine of a dwelling place of the dead is inserted into Strong's Concordance as a reference. The reference in Revelation where they are tormented day and night forever, their smoke ascending forever could refer to something captured on film, therefore forever preserved. The reference in Mark 9:44: "Where their worm dieth not and the fire is not quenched" I believe is another example of that. It just does not make sense of a maggot that never dies.
All said, as I stated before all scripture has to fit together, in what we teach, or none of it is valid. Some things were presented in parables with figurative speech. Some things maybe we don't quite understand yet. God will not reveal some things until He is ready for us to know.
I feel Lazarus and the rich man is a parable despite the proper names. Besides it is just in one place in scripture without a second witness. 2 Cor. 13:1 "This is the third time I am coming to you. In the mouth of two or three witnesses shall every word be established."
Our ambitions are also asleep and preserved. Exactly how God does this I do not know. Acts 7 and 8 says nothing other than a vision of Stephen and a statement from him for God to receive his spirit. The Father does preserve the spirits but they are not conscious. Here are some references to the unconscious saints.
Ecclesiastes 9:5,6: “For the living know that they shall die: but the dead know not any thing, neither have they any more a reward; for the memory of them is forgotten. Also their love, and their hatred, and their envy, is now perished; neither have they any more a portion for ever in any thing that is done under the sun.”
Psalms 6:5: “For in death there is no remembrance of thee: in the grave who shall give thee thanks?”
Psalms 30:9: “What profit is there in my blood, when I go down to the pit? Shall the dust praise thee? shall it declare thy truth?”
Psalms 115:17: “The dead praise not the LORD, neither any that go down into silence.”
Isaiah 38:18: “For the grave cannot praise thee, death can not celebrate thee: they that go down into the pit cannot hope for thy truth.”
Psalms 88:10-12: “Wilt thou shew wonders to the dead? shall the dead arise and praise thee? Selah. Shall thy lovingkindness be declared in the grave? or thy faithfulness in destruction? Shall thy wonders be known in the dark? and thy righteousness in the land of forgetfulness?
Psalms 115:17: “The dead praise not the LORD, neither any that go down into silence.”