Excellent question @Alive_In_Christ - and if you get five Christians together on this topic, you’ll likely get seven opinions!
But one of the mainstream positions in our day that I think can be well articulated from scripture is that when a believer dies, his soul is absent from the body and present with the Lord (II Corinthians 5:8).
The body sleeps in the grave until the resurrection at the end of this age when the Lord returns with the souls of the departed who are then reunited with their new, resurrected bodies (I Thessalonians 4:13-18) which are made as miraculous as Christ’s resurrection body (Philippians 3:20-21).
The best explanation for this is that in heaven, the soul does not need a physical body (which would actually be an impediment in that spiritual environment). But to interact with this world, a physical body is very useful - and we are destined to reign with Christ over this world.
When Jesus returns, and us with Him, we will reign with Him for 1000 years (Revelation 20:1-6). It will be the final age of mortal history and of mankind’s story in a fallen world.
Although it is still under the curse of sin, Christ’s beneficent rule will greatly mitigate the ills of former times so that the lion will lie down with the lamb, nation will not lift up sword against nation, every man will dwell securely beneath his own vine and fig tree, the knowledge of the Lord will cover the earth as the waters cover the seas, and mortal men born into that world (descended from the Tribulation survivors) will live as long as trees. (Multiple verses for this, but an easy Google search will take you to them all.)
But at the end of the 1000 years (often called the Millennial Kingdom), there will be a final rebellion against Christ at Jerusalem (Rev. 20:7-10), because even men born in that perfect kingdom will have inherited a sin nature. And contrary to what some say in our day, a utopian environment would not really change our basic depravity.
The heavens and the earth which are now will be dissolved by fire (II Peter 3:10-13). And in that spaceless, timeless limbo between the passing away of the sin-cursed creation, and the making of the new, Christ will sit upon His Great White Throne to judge all the lost souls of all the ages (Revelation 20:11-15).
Immediately afterward, God will make the new heaven and the new earth which He rules over from the New Jerusalem (Rev. 21:1-2). This unstained creation does not groan under the curse of sin as the former (Romans 8:22-23). And God will dwell on this perfect creation with all the redeemed in their glorious bodies forever. And He will even share His rule over it with us (Rev 3;21)!
I hope this helps with what you were looking for.