Lookup across multiple spreadsheets

[Rob76]

Hi, I was wondering if it is possible to auto grab and insert data (via Lookup??) between two different spreadsheets (in different folders)

eg,
Grab data from Cell A1 in "C:\Excel01\Spreadsheet01.xls"
and place into Cell B1 in "C:\Excel02\Spreadsheet02.xls"

Any help would be a life saver!

Thanks

[mrice]

Something like

=VLOOKUP(A1,'C:\Documents and Settings\Martin\My Documents\[Book2.xls]Sheet1'!$A$1:$B$1,2,0)

should do the trick.