How to merge a alreg number of sheets into one sheet

Hi,
I have an Excel file which consists of several sheets. I can select all sheets but how do I merge the content into one sheet. The sheets only contain text so I don't have to summarize data.

Best regards,
Gro

Hi and welcome to the board,

there's a solution at Ron debruin's site

HTH