The Bible teaches plainly that no one other than Jesus Christ goes to heaven.
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.
The hope of the gospel is that of resurrection from the dead to an eternal inheritance in the kingdom of God on earth.
So we read:
Matthew 5:5 Blessed are the meek: for they shall inherit the earth.
Psalms 37:9 For evildoers shall be cut off: but those that wait upon the LORD, they shall inherit the earth.
Psalms 37:11 But the meek shall inherit the earth; and shall delight themselves in the abundance of peace.
Psalms 37:22 For such as be blessed of him shall inherit the earth; and they that be cursed of him shall be cut off.
Psalms 37:29 The righteous shall inherit the land, and dwell therein for ever.
Psalms 37:34 Wait on the LORD, and keep his way, and he shall exalt thee to inherit the land: when the wicked are cut off, thou shalt see it.
Isaiah 60:21 Thy people also shall be all righteous: they shall inherit the land for ever, the branch of my planting, the work of my hands, that I may be glorified.
Romans 4:13 For the promise, that he should be the heir of the world, was not to Abraham, or to his seed, through the law, but through the righteousness of faith.
Galatians 3:18 For if the inheritance be of the law, it is no more of promise: but God gave it to Abraham by promise.
Galatians 3:29 And if ye be Christ’s, then are ye Abraham’s seed, and heirs according to the promise.
God says to Jesus
Psalms 2:8 Ask of me, and I shall give thee the heathen for thine inheritance, and the uttermost parts of the earth for thy possession.
Contrary to popular belief, we do not possess an immortal soul or spirit which goes to heaven when we die.
In death we remain unconscious in the grave until Christ returns to raise and judge the dead.
Ecclesiastes 9:5 For the living know that they shall die: but the dead know not any thing…
Ecclesiastes 9:10 Whatsoever thy hand findeth to do, do it with thy might; for there is no work, nor device, nor knowledge, nor wisdom, in the grave, whither thou goest.
Psalms 146:4 His breath goeth forth, he returneth to his earth; in that very day his thoughts perish.
Psalms 6:5 For in death there is no remembrance of thee: in the grave who shall give thee thanks?
When Christ returns the dead will be raised out of the grave.
John 5:28 Marvel not at this: for the hour is coming, in the which all that are in the graves shall hear his voice, 29 And shall come forth; they that have done good, unto the resurrection of life; and they that have done evil, unto the resurrection of damnation (condemnation).
In the resurrection we will be recognisable as ourselves.
May I suggest that you read:
Your Share in God’s Promises https://www.thisisyourbible.com/library/show/181
The Kingdom of God on Earth https://www.thisisyourbible.com/library/show/170
After Death – What? https://www.thisisyourbible.com/library/show/43
I hope you find this helpful.