Fin Fang Foom wrote...
I implemented a your solutions and I'm getting a #REF! error. Maybe
this might be the problem. When you say

N: the number of rows in the common ranges in each of the worksheets
in WSLST

I defined it the number 8 in my named ranges. Or else I dont know what
I'm missing.

Yes, N should refer to 8. That can be checked: the formula =N should
return 8. Did you name your list of worksheet names WSLST? If so, what
are your actual worksheet names?