Combine Data From Multiple Spreadsheets

You can use VLOOKUP to combine multiple tables into one, as long as one of the tables has fields in common with all the others.