We'd need more detail to answer that, Elton, but let's start here: What do you mean by "a name association"? How (for example) are four particular cells in a worksheet "associated" with that worksheet's name?

My next question might be where you said "I need to locate all worksheets in the workbook that have that name". If the first worksheet is named "Worksheet-A" (for example), then there's no point in going through the workbook to see what other worksheets are named "Worksheet-A"; only one worksheet can have that name. But one question at a time; maybe your answer to the first question will clear up the second before I ask it.