ok so you could use =INDEX(INDIRECT($A$1),ROW()-1) and drag down, but as you have varying depths of range I'm not sure formula is the best method, I would be going for a vba solution