Append Named Ranges one under the other to form a new Range

[TamirBasin]

Hi,
I have many ranges on the same sheet, each contains exactly 1 column.
Range1, Range2, Range3...etc.

I need to create a combined range ("AppendedRange") that will append all the ranges, one under another (for vlookup purposes)
Range1 (values)
Range2 (values)
Range3 (values)
etc.

I got lost with trying to loop and update the last row of the AppendedRange.

I would appreciate any help.
Thanks,
Tamir

 

[TamirBasin]

It seems to work great
I still have to try various scenarios and see how the code holds.
Thank you so much
Tamir