How to select a cell from another work sheet base on a formula

I have a datasource worksheet and output work sheets. I
want to want to link a cell in datasource work sheet on
the outputwork sheets base on a formula.

For example:

datasource work sheet
a10 Steve
a11 Male
a12 work at home
a13 Sue
a14 Female
a15 work at officev
a16 Mary
a17 Female
a18 work at office

on output1 work sheet
a1 1 (I create this value for used in formula)
a2 Steve

on output2 work sheet
a1 2 (I create this value for used in formula)
a2 Sue

Since I need to create 10 output work sheets base on one
datasource sheet, I need to have the a2's (on output
sheet) value base on a formula.
somthing like =datasource!a(10 + (value(a1)-1)*3)

What is the correct systex for this formula? or Any other
way to do it?

Thank you for your help!

Jane

... I need to have the a2's (on output
sheet) value base on a formula.
somthing like =datasource!a(10 + (value(a1)-1)*3)

In each of your output sheets:

Try in A2:
=INDIRECT("datasource!A"&(10+(A$1-1)*3)+ROW(A1)-1)
Copy A2 down to A4

This will return the 3 lines of data for each person
which you have in the sample data
in A10:A18 in "datasource"

For example in sheet: output1

You have put in A1: 1
A2 will return "Steve"
A3 will return "Male"
A4 will return "work at home"

--
Instead of formulating in 10 sheets,
might be easier to just create one output sheet first,
then make* another 9 copies of the sheet,
then rename the tabs and change the values in A1
(via example: Edit Move or Copy Sheet)
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik atyahoodotcom
----
"Jane" wrote in message
...
I have a datasource worksheet and output work sheets. I
want to want to link a cell in datasource work sheet on
the outputwork sheets base on a formula.

For example:

datasource work sheet
a10 Steve
a11 Male
a12 work at home
a13 Sue
a14 Female
a15 work at officev
a16 Mary
a17 Female
a18 work at office

on output1 work sheet
a1 1 (I create this value for used in formula)
a2 Steve

on output2 work sheet
a1 2 (I create this value for used in formula)
a2 Sue

Since I need to create 10 output work sheets base on one
datasource sheet, I need to have the a2's (on output
sheet) value base on a formula.
somthing like =datasource!a(10 + (value(a1)-1)*3)

What is the correct systex for this formula? or Any other
way to do it?

Thank you for your help!

Jane