I´m writing my first addin and I´m having the following problem:

I have a workbook which retrieves data from a database. With the addin I
create a new menu that has the update functions. One update function should
be renaming 6 sheets in the workbook. Of course, once renamed, the sheets
have a different name the next time I use the update, so I want to use the
codename of the sheets as the reference. But I read somewhere that I can´t
use codenames to reference to sheets in a different workbook, hence it
wouldn´t work from the addin either.

Is there a solution or workaround to this problem?
Thanks.