So when they say all of the stars in the sky are moving away from us quicker and quicker, and these stars will no longer be able to be seen in future, how does that jive with Andromeda moving closer and closer, and eventually colliding with us?
So everything except Andromeda is moving faster and faster away from us?
That does not make sense.
Imagine your class goes on a school trip to a balloon factory.
At a balloon factory, before the latex rubber sheets are processed in to balloons, they can be quite large, like the size of tarps. Now let's say for fun purposes, one of the tarps is cut in to large circle, and your class is permitted to play around with it in the visitors' area. Now the science teacher proposes an experiment:
Two kids stand in the middle of the sheet, and the rest of the class spreads around the perimeter and grabs hold of the edges with both hands. The teacher says "now pull everyone!" and the rubber expands, slowly getting larger and larger.
Then the teacher says "okay, you two in the middle, step slowly towards each other," and in a couple moments, they're close enough to touch. How was such a thing possible?
It was possible because the speed of the two objects in the middle moving towards each other was greater than the speed in which the sheet was expanding.
Remember, if everything's indeed expanding in the universe, then the same is true on Earth. And yet, I'm still able to reach over to the table and pick up my glass of iced tea without it flying away from me. That's because the universe is expanding in
a relative way.
Not unlike how the Earth is spinning around its axis at 1,000mph, while rotating around the sun at 66,000mph, while the Solar system is rotating around Sagittarius A* (the massive black hole at the center of the galaxy) at a speed of 448,000mph, while the Milky Way is also flying through space. We just don't notice it.
Or another way to look at it is that gravity can be a game-changer in these situations. For example, the Earth as a whole is held together by gravity despite all the spinning & flying, and despite the universe expanding. That's also true up to the local cluster of galaxies... up to a point. Eventually, far in the future, that may be less true, when the force of expansion is greater than gravity's ability to knit things together. Indeed, the universe may ultimately be headed towards a
Big Rip.
AFAIK the very strongest natural forces (indeed, much stronger than gravity) that can resist the expansion are atomic forces (strong & weak force), followed by molecular bonds. Those will pretty much be the last things to go in a Big Rip scenario.
Getting back to the point-- not unlike how our lives go on Earth, the Milky Way and Andromeda don't 'notice' that the universe is expanding because their speed and mutual attraction is far greater at the moment. As for what the galactic merger will look like? It should be something like this:
Thanks for coming to my very amateurish TED talk. :D