I am trying to get the index of a worksheet by using the CodeName of the worksheet. What I need to do is pull information from a worksheet and update data on a corresponding worksheet. For example, if the CodeName of the Worksheet is Sheet401, I need to place the updated data on the CodeName Worksheet called Sheet501. I cannot use the Name of the sheet as it will change often but the CodeName will not change.