Time delay to change cell reference

Hi Guys,

I need a code which will take a lump of data, B2:AW366 and cycle through the data in a single cell (A1)

So to clarify Cell A1 should cycle through:

B2
C2
D2
E2
...
...
...
AU2
AV2
AW2
B3
C3
D3
E3
.....
.....
Continue until cell AW366 reached.


If possible i would like the speed of the cycle to be variable, So i can select a 0.5 second delay before Cell A1 changes to the next reference.

Many Many Thanks