Link 3 Worksheets that have common field

[bdids]

I have copied 3 foxpro dbf files to Excel (2007). The field that all 3 have in common is named "Stock ID". I need to create a report pulling 1 or 2 fields from each file (or worksheet). Is there a way to do this in Excel, possibly using Pivot Tables or is there some other way? Thank you!