Change sheet name into formula

[Vishal2050]

Dear All,

I have an excel file say "A" into which data is linked through other file say "B" having 15 number of sheets with equal order

After getting data into File A, manually I have to change the sheet name. Is there any way to change the sheet name automatically.

Non VBA solutions would be appreciated

Thanks in advance!!

Regards
Neeraj Kumar Agarwal

 

[Joe4]

Is there any way to change the sheet name automatically.

Non VBA solutions would be appreciated

No, I don't think that is possible without VBA.
Whenever "automatically" is introduced, it almost always require VBA.