Combining Multiple sheets of Data

[Welsh Mark]

Hi,

I have a spreadsheet with 52 sheets of data. Each sheet in in the same format (Ie contains the same number of columns in the same order).

Rather than manually cut and paste this data into one sheet is there any quicker way or a foumula / process I can use?

 

[Welsh Mark]

I forgot to mention the sheets are not named sheet 1 sheet 2 and so on but each have defined names.

 

[Albeni]

Hi,
I use an additional utility named ASAP Utilities - it's free and very helpfull.