Hi Christina,
let's say that the names are in column 1 in Sheet 1 & 2 so in column 2 of
sheet 1 enter
=VLOOKUP($A4,Sheet2!$A$:$J$,2,FALSE)
A to J are all the column from where you want to bring the information, then
copy the formula to the others columns and change 2 in the above formula with
3 to bring information from column 3 of Sheet 2 and so on

"Christina" wrote:

I am trying to create a spreadsheet that has a lot of information. I would
like to be able to pull information from one sheet to another.

An example, i would like type in a name and have the rest of the sheet
populate with the information corresponding to that name.
ie. I would like to enter Microsoft and have about 10 fields automatically
calculate and generate the information into sheet one. I have all of the
information in Sheet 2

Please help. Thanks,