When each of us dies, our souls are immediately taken to the presence of God and judged. This is called the Particular Judgment. At this point we begin our eternal destiny. If we are going to hell, our souls go directly there. If we are deemed worthy of heaven, our souls will go directly to heaven, or if we are going to heaven but are in need of purification, we may go to Purgatory first for a while (everyone in Purgatory will eventually go to heaven). Whatever our fate, our souls will stay there (heaven or hell) until the end of time, at which time the Second Coming will occur.
At the Second Coming at the end of time, those Christians still alive will be taken to heaven (what some Protestants think of as of the rapture). Then will occur the General Judgment. At that time the souls of the living and the dead will be reunited with their bodies and brought together in God’s presence and judged before all. Those who have already been judged in the Particular Judgment will be brought from wherever their souls were -heaven, hell or Purgatory-- and have their judgment confirmed before all, so that both the justice and mercy of God will be manifest to all.
After this, time and Purgatory will be no more and all will enter with their souls and bodies into their eternal destiny, either hell or heaven.
This is an extremely bare-bones sketch, so if you want to get the details, see the five articles I linked below:
rosary-center.org/ll57n1.htm
rosary-center.org/ll57n2.htm
rosary-center.org/ll57n3.htm
rosary-center.org/ll57n4.htm
rosary-center.org/ll49n6.htm
In addition, you have to learn to recognize erroneous teachings about the End Times popularized by fundamentalists. In other words, toss out the “Left Behind” and “Late, Great Planet Earth” baloney. Here are some resources to help you develop some discernment in these areas:
catholic.com/library/rapture.asp
catholic.com/thisrock/2000/0011fea2.asp
catholic.com/library/false_profit.asp
catholic.com/thisrock/2002/0211fea3.asp
catholic.com/thisrock/2000/0001fea1.asp
catholic.com/thisrock/1995/9510ntg.asp
catholic.com/thisrock/2002/0209fea5.asp
catholic.com/thisrock/1998/9812chap.asp
catholic.com/thisrock/2003/0304bt.asp
catholic.com/thisrock/1997/9705chap.asp
catholic.com/thisrock/1994/9409fea4.asp
catholic.com/thisrock/1994/9410fea2.asp
catholic.com/thisrock/2000/0009bite.asp
carl-olson.com/rapture_articles.html
Finally, here are some resources to help you develop a well-balanced Catholic understanding of the Book of Revelation, biblical prophecy, and eschatology. All of these are HIGHLY recommended:
The Navarre Bible Commentary on the Book of Revelation
The Navarre Bible Commentary on the Major Prophets
The Navarre Bible Commentary on the Minor Prophets
amazon.com/gp/search/ref=br_ss_hs/102-2381711-9848916?platform=gurupa&url=index%3Dblended&keywords=navarre+bible
The End: The Book of Revelation, tape/CD series and Study Guide by Dr. Scott Hahn.
saintjoe.com/more-info.php?product=177&Title=The-End
The Lamb’s Supper, by Dr. Scott Hahn.
amazon.com/gp/product/0385496591/sr=8-1/qid=1148926012/ref=pd_bbs_1/102-2381711-9848916?%5Fencoding=UTF8
Rapture: The End Times Fiction that Leaves Truth Behind, by David Curie
sophiainstitute.com/Merchant2/merchant.mvc?Screen=PROD&Store_Code=SIP&Product_Code=72-5&Category_Code=Current
Revelation Revealed, tapes/CD series by Michael Barber
saintjoe.com/search-result.php
Coming Soon, a book on this same topic by Michael Barber
amazon.com/Coming-Soon-Unlocking-Revelation-Applying/dp/193101826X
Introduction To Prophecy, CD set by Steve Wood
familylifecenter.net/cart/product_detail.cfm?Id=613