How to pull names and fields

[Guest]

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]

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