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,