The property of being "closed under limits" is more formally referred to as completeness. To talk about what this means we need the definition of a Cauchy sequence:
Definition: A sequence $(a_n)_{n=1}^\infty$ of points in $\mathbb{R}$ (or $\mathbb{Q}$, or $\mathbb{Z}$, etc.) is a Cauchy sequence if for all $\varepsilon>0$, there exists a natural number $N$ (depending on $\varepsilon$) such that whenever $m,n\geq N$, $|a_n-a_m|<\varepsilon$.
Hence a Cauchy sequence consists of points which may not eventually get arbitrarily close to some point in your space, but do get arbitrarily close to each other. However, if you draw what a Cauchy sequence of real numbers should look like, you'll probably notice that the points that you draw do seem to actually approach some point! This is because the real numbers are complete: all Cauchy sequences are actually convergent sequences, i.e. every Cauchy sequence in $\mathbb{R}$ converges to some point in $\mathbb{R}$.
How is this different for the rationals? B. Goddard gave a great example; the Cauchy sequence of truncated decimal expansions for $\pi$ is convergent to $\pi$ in $\mathbb{R}$ (it has to be, since the real numbers are complete!), but cannot converge in $\mathbb{Q}$. If it did, then that would imply that $\pi\in\mathbb{Q}$.
We can think of points like $\pi$ as being "holes" in the rational numbers that the real numbers fill in. In fact, the real numbers are the completion of $\mathbb{Q}$; that is, the smallest complete space containing $\mathbb{Q}$. This is why the real numbers "contain the limits of all sequences of rational numbers" - they are in fact precisely constructed to fit this role.