Is the xylem like a tissue paper?
I'm in year 5 too; and (with a bit of help of my dad) I have some bits of answers (my challenge of the day).  

A paper tissue is principally made of cellulose. And cellulose is a polar molecule. And so is water. So, the paper will easily absorb water.
See these short clips [1] for water polarity and here for cellulose [2].

In plants, xylem vessels are also made of cellulose and that helps the small molecules of water to stick to the vessels walls.
Think of it as a lot of tiny drinking straws made of wood.

There are at least two reasons why water manages to 'climb up' from the roots to the leaves through the xylem.

During the day, when the sunlight is available, water will be consumed by the leaves during photosynthesis [3]. For each molecule of glucose, 6 molecules of water are needed.
So the water already present from the xylem in the leaves needs to be replenished by water (sap) from the twigs, which is replenished by the water from the xylem in the branches,... And so on, till the water is pulled from the roots.[4]
Remember little molecules of water cling to each other because they are polar.  This is why they tend to pull each other up, as they are consumed in the leaves [1'].  

And this is why it is important that both the water molecule and the cellulose molecule are polar.  If H2O would be like CO2, there would be no vascular plants as we know them.

But there is no sun, so no photosynthesis, during the night.
Then the stomata, which are holes used by vascular plants to "breath" (
transpiration), are usually closed.
There is also another reason why water moves up the xylem. Here it is.
Roots not only 'pump' water, their role is also to capture nutrients. 
These nutrients are like salts, not table salt, more like ions (potassium, phosphorus, zinc, mangnese, etc) which are needed by the plant cells.
So the water is a bit more 'salty' inside the roots.  Water outside the roots tends to try to diffuse into the roots in order to compensate the relative saltiness [5].
This in turn pushes the water from the root below the ground towards the branches.[4]

What is remarkable is that the whole cycle of water is passive, the plant does not spend energy to move the water 'upwards' to the leaves.

Here are a few sources which I can recommend and from which I learned most of these things. Crash course biology. 
They talk fast but it's quite funny.

[1] water polarity: 'Water - Liquid Awesome: Crash Course Biology #2'
https://youtu.be/HVT3Y3_gHGg?list=PL3EED4C1D684D3ADF&amp;t=171
[1'] To picture molecules of water pulling one another up the xylem... well:
https://youtu.be/IlmgFYmbAUg?t=154 (Monkey chain in Madagascar 3)

[2] cellulose: ' Plant Cells: Crash Course Biology #6'
https://youtu.be/9UvlqAVCoqY?list=PL3EED4C1D684D3ADF&amp;t=255  

[3] Photosynthesis ' Photosynthesis: Crash Course Biology #8'
https://youtu.be/sQK3Yr4Sc_k?list=PL3EED4C1D684D3ADF&amp;t=75

[4] For a simple presentation of xylem, I use Simple English in
https://simple.wikipedia.org/wiki/Xylem_vessel
and 'Vascular Plants = Winning! - Crash Course Biology #37'
https://youtu.be/h9oDTMXM7M8?t=373

[5] Osmosis (water compensating solutes) "In Da Club - Membranes &amp; Transport: Crash Course Biology #5"
https://youtu.be/dPKvHrD1eS4?list=PL3EED4C1D684D3ADF&amp;t=148

Ian (and dad &lt;= all errors and approximations are his :) ).