hi guys,

i just want to ask if there exists an easy way of linking a number of cells which looks like this:

suppose i've a number of data in "Sheet1" at the cells "A5,A10,A15,A20... " and goes periodically. I want to link these periodic data to a row in "Sheet2" for example to the cells "B4,C4,D4,E4,F4,G4,H4...." and goes on like this.

now i'm doing this by simply clicking in every reference cell, but i hope there's an easy way to do this.

thank you so much...