in A10, put this formula: =INDIRECT("A"&COLUMN($A$1))
Then, in A11: =INDIRECT("R1C"&(1+COUNT($A$10:A10)*5);FALSE)
You can copy this down, as needed...
Pay attention to your regional settings, you might need to change the separators in formula from ";" to ","