How do you consolidate tables contianing text?

[samenvoegen van sheets]

I need to consolidate a lot of sheet together but some of the cell are
containing text. I can't find a way to consolidate the sheet in order to see
the text in the consolidate sheet.
Hox do i have do to, if i need the text to appear?

thanks a lot, brgds,