I'd guess you'd want to use =vlookup() or =index(match())

And Debra Dalgleish has some nice instructions (for both) at:

http://www.contextures.com/xlFunctions02.html
and
http://www.contextures.com/xlFunctions03.html

Brian S. wrote:

Hello can anyone tell how I can get Excel to pull data from different
worksheets if the common thing between them is a person name.

--

Dave Peterson