macro to extract data of a selected sheet
 

I have a w/book contains 120 sheets all contains similar data columns.I have
a anlysis sheet in which data analysis tools are placed in a1:m35.I am
looking for a macro to look sheetname(in a1 sheetnames list is placed) and
relevant data of that sheet be loaded to analysis sheet from N1 onwards.

macro to extract data of a selected sheet
 

Have you had a look at the INDIRECT function? I think it will do what
you want.
Rgds,
ScottO

"TUNGANA KURMA RAJU"
wrote in message
...
| I have a w/book contains 120 sheets all contains similar data
columns.I have
| a anlysis sheet in which data analysis tools are placed in a1:m35.I
am
| looking for a macro to look sheetname(in a1 sheetnames list is
placed) and
| relevant data of that sheet be loaded to analysis sheet from N1
onwards.