Your code worked perfectly for the example that I posted. But what I am wondering is if it will work for workbook that has worksheets that automatically change sheet names. For Instance, all my worksheets are named with a part number such as 071-000-438 and a changing percentage such as (20.37). So a sheet will be named something like "071-000-438 (20.37)" for the month of January. Then during the next month, that percentage will change and the tab name will also change. So in February that percentage becomes 23.73, the tab name will now be "071-000-438 (23.73)". Your code looks for a sheet named "071-000-438" and if it does not find one, it creates one. I am wondering if this can be modified to look for a sheet that just contains "071-000-438".