Heaven is where YHWH the Father resides (1 Kings 8:30; Psalm 2:4; Matthew 5:16).
We read that flesh and blood cannot inherit the Kingdom of Heaven (1 Corinthians 15:50); only Spirit-beings can reside within it.
Even a righteous man like King David, whom YHWH called a man after His own heart, is not in Heaven.
“For David did not ascend into the heavens” (Acts 2:34).
Yahushua confirmed this when He said,
“No one has ascended into heaven but He who came down from heaven, that is, the Son of Man who is in heaven” (John 3:13).
Human beings who have died are now in the grave awaiting resurrection (Ecclesiastes 12:7).
Some will be resurrected physically to be judged; others will be resurrected as Spirit-members of the Kingdom of Heaven.
Yes, when Christians are resurrected as Spirit-beings they will inherit all things (Romans 8:32; Revelation 21:7). That inheritance includes access to YHWH the Father in Heaven, even while they serve under Yahushua ruling on the Millennial planet Earth!
For a good reference get this book: