How can you pull specific data from various Excel workbooks and import it into the correct fields on another sheet?
Rajesh Pathak
VLOOKUP function can be useful here. You can easily pull data using VLOOKUP.

You can use VLOOKUP on same worksheet, on different worksheets and even on different workbooks.

Homepage
MS EXCEL TRAINING​​​