Transpose Multiple worksheets into 1 main worksheet

[umair434]

Hi,

I have an excel file with 50 tabs (each tab is a worksheet with the same format). I want to come up with a single master worksheet which will have all the 50 tabs transposed and presented under each other.

Each tab is a week - so the master worksheet should be like

week 1
week1
week1
week1
week1
week2
week2
week2... and so on. Is there any quick method of doing this than transposing each worksheet and copy pasting manually.

thanks guys! your help is very appreciated!

umair

 

[GinaWhipp]

Have a look here...
http://www.rondebruin.nl/tips.htm

Specifically...
http://msdn.microsoft.com/en-us/library/cc793964.aspx