I have an application that create a number of separate workbooks, identicai
in format.. Each workbook has a series of worksheets, each having a codename.

I now have master workbook that opens each of the above in turn. I wish to
refer to the worksheets by their codename, but my master application fails to
compile as the codename is not recognised.

Is there a way around this? I do not wish to refer to the remote worksheets
by name as these may have changed.

Cheers