Move information between different workbooks?

[Sp4rt4n]

How would you get excel to compile from 20 different sheets onto a whole separate one?
If there was a way that would be awesome... Like... take information from B24 from fileone.xls and put it on B55 of compiled.xls

[starguy]

How would you get excel to compile from 20 different sheets onto a whole separate one?
If there was a way that would be awesome... Like... take information from B24 from fileone.xls and put it on B55 of compiled.xls

you can link cells like this
put in B55 of compiled.xls
='[fileone.xls]sheet1'!$B$24

let me know if you require something different.
do not forget to provide data references of your workbooks.

Regards.