Hi,

I have 11 WBs structured exactly the same way.
Every WB contains 30 WSs, the WSs Tab names are the same for every WB.
I need to change some tab names, which means that I have to reflect all the
changes to the formulas, macros etc.
If I do all of this in one WB, what could be the best way to apply the same
changes to all the other 10 WBs?
Basically, if I change some of the tab names in one WB and fit the formuals
and the macros accordingly, then I will need to do the same job in the other
10 WBs.
I'm asking if there's a short way to this, like for instance a batch process
or so.

Thank you for your help.

Alex