Problem on linking different cells from other worksheet ?

There are 2 worksheets A and B. Worksheet A contains many groups of data,
such as Name, Age, ***, Address, ... which locate on different cell position,
E7, H6, H7, H8, and the same information for next group will locate on E15,
H14, H15, H16.

I would like to link
A!E7 into B1
A!H6 into C1
A!H7 into D1
A!H8 into E1

A!E15 into B2
A!H14 into C2
A!H15 into D2
A!H16 into E2

and I would like to do the rest, but I cannot link the rest of cells by
dragging B1:E2 into E100, each cell just does not align with my intended cell
value.
Does anyone know on how to do it in Excel?
Thank you in advance
Eric

B1: =INDIRECT("A!E" & ROW()*8-1)
C1: =INDIRECT("A!H" & ROW()*8-2)
D1: =INDIRECT("A!H" & ROW()*8-1)
E1: =INDIRECT("A!H" & ROW()*8)

and copy down as far as needed

HTH,
Bernie
MS Excel MVP


"Eric" <Eric@discussions.microsoft.com> wrote in message
news:95F16448-9343-4075-8FC3-4AABAA5931B2@microsoft.com...
> There are 2 worksheets A and B. Worksheet A contains many groups of data,
> such as Name, Age, ***, Address, ... which locate on different cell position,
> E7, H6, H7, H8, and the same information for next group will locate on E15,
> H14, H15, H16.
>
> I would like to link
> A!E7 into B1
> A!H6 into C1
> A!H7 into D1
> A!H8 into E1
>
> A!E15 into B2
> A!H14 into C2
> A!H15 into D2
> A!H16 into E2
>
> and I would like to do the rest, but I cannot link the rest of cells by
> dragging B1:E2 into E100, each cell just does not align with my intended cell
> value.
> Does anyone know on how to do it in Excel?
> Thank you in advance
> Eric

Thank you very much
Eric