At the end of time, the Kingdom of God will come in its fullness. Then the just will reign with Christ for ever, glorified in body and soul, and the material universe itself will be transformed. God will then be "all in all" (1 Cor 15:28), in eternal life.
Source: Catechism of the Catholic Church (Vatican.va)