Hello,

Can you please reload your workbook but this time include the expected result?
I will have a crack at it (no promises) but it would help for me to see what result you are trying to achieve.

Also, on your attachment, Cell A2 has a #NAME? error, which in my understanding comes from the range you have set 'SheetNames' not being defined, by this i mean you have told excel to look in the range 'SheetNames' but you have not actually set that range.

Regards