I need help on Sheet nemae

[k_2]

hello, in my document i have a lot of sheets and i need formula or macros which will write all sheets name in one sheets , i need to use indirect function and i need sheets name list and aloso i need if it is possible to make table for sheets names and every sheet has a name which is written in rows , thanks for attention and sorry for my bad English

[sunil.excel]

See the attachment........

[sunil.excel]

thanks.................

[k_2]

thanks that is exectly what i need , but is it possible to do vice versa? to write in cels text and macros convert this text as a sheet name?

[sunil.excel]

Try this........

[k_2]

i attached file and i think you will understand what i need, in collm c there are text which i want to be my next sheets name

[k_2]

attachment