Hi Good morning all .. need a help

[amit dev thapa]

I have a information in multiple sheets ..data are in Row .. i wanted to create a summary sheet .. where data will be in column ..iI am attaching the file , i can do Transpose .. but the number of sheets are around 40 , i have just added 6 sheet as a sample

 

[Hui]

Select D3:Y3
=TRANSPOSE(INDIRECT(C3&"!C3:C24")) Ctrl+Shift+Enter
Copy D3:Y3 down

This will work as long as the structure is the same in all worksheets

 

[amit dev thapa]

Select D3:Y3
=TRANSPOSE(INDIRECT(C3&"!C3:C24")) Ctrl+Shift+Enter
Copy D3:Y3 down

This will work as long as the structure is the same in all worksheets

Thanks a lot for your prompt response.. it is working .. may i ask where do we use indirect .. what is C3&

 

[amit dev thapa]

Select D3:Y3
=TRANSPOSE(INDIRECT(C3&"!C3:C24")) Ctrl+Shift+Enter
Copy D3:Y3 down

This will work as long as the structure is the same in all worksheets

ok got it .. can I take data from different sheet to other worksheet same formulae