Fin Fang Foom wrote...
....
When I added more cells in the Define Name area it gives me a VALUE
error. Here what I got:

Arrays =EVALUATE("{"""&SUBSTITUTE(Temp,",",""",""")&"""}" )

Temp =Temp1&","&Temp2&","&Temp3
....
It works for Temp1 & Temp2 but if I add Temp3 it gives me that error.
What do you think the problem is?

I should have foreseen this. EVALUATE's argument can only be so long,
and it appears you've bumped into that limitation. At this point I
believe you need to abandon any hope of elegance and use a LOT of cell
formulas. Basically, you'd need to split out the contents of
<whatever!D2:D300 into separate cells.