Need to know how to create program in Excel.?

Question

I want to take data from one sheet and transfer it onto another sheet.
This does not involve a simple copy or cut and past.
Thus,
The data on one sheet will be in rows eg /Jeff/ 56 / 78 / 897 / 789 /
/Lisa/ 890 / 765 / 6789 / 2344/
/Jane/ 8 / 34 / 7832 / 7893 /

On the second sheet, i want to automatically obtain or retrieve the numeric data for Jane by typing in "JANE'' ,
Lisa by typing in "LISA
or
Jeff by Typing in "JEFF''
Thus regardless of the order in which i enter a name in a given column in the second sheet, i want the numeric data for that individual to load up along that row.
Is this possible?
What are the steps?
Thank you

Answer 1

Excel Pivotables are designed to the solve the problem you just described.

Answer 2

I have a spreadsheet like this (more complex though) ....where I have data entered on page 1, and it automatically updates information on other pages. There is a formula you have to enter for each block.
Lets say on PAGE 1; JEFF (in rows) is in A,1, 56 is in B,1, 78 is in C,1, ....
Now lets say you want the information to also be on PAGE 2...
JEFF (in Columns) is in A,1, 56, in A,2, 78 in A,3,....
I'm sure you'll catch on after you play around
On page 2, in A,1, (JEFF) type the formula =PAGE 1!A1
On page 2, in A,2, ( 56 ) type the formula =PAGE 1!B1
On page 2, in A,3, ( 78 ) type the formula =PAGE 1!C1
The (=) equal sign signals a function, the "PAGE 1" should be the name of the page where the data was initially entered, the (!) exclamation must be there for the function to work, and the A1 is of course the box on the first page where the information is.
Now you do it.

Answer 3

In A1 of Sheet1, type abc

In any cell of Sheet2, type =(Sheet1!A1)

It will reference the value in Sheet1