pull data from 5 different spreadsheets

[guerillaexcel]

is it possible to pull in data from 5 different spreadsheets to a new spreadsheet?
For example:

spreadsheet 1 has car names
spreadsheet 2 has peoples names
SS 3 has cities
SS 4 has countries
SS 5 has towns

I'd like to have a 6th spreadsheet that pulls in the information from the above to a worksheet that I'll then be doing a pivot-table on this data.
Do-able?
Thanks

[martindwilson]

same or different workbooks? also what is common between them all?