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

 

[stanleydgromjr]

Adjust the below formula:

='C:\Documents and Settings\?????\My Documents\?????\[filename.xls]Sheet1'!$A$1

1. adjust the ????? with the correct foldername(s)
2. adjust the filename with the correct file name
3. adjust the Sheet1 name with the correct sheet name
4. adjust the cell address $A$1 with the correct address from filename

Copy the adjusted formula (see instructions above) into cell B55 of 'compiled.xls':
='C:\Documents and Settings\?????\My Documents\?????\[filenone.xls]Sheet1'!$B$24


I am using Windows XP Professional SP2, and Excel 2003 SP2,

Have a great day,
Stan

 

[Sp4rt4n]

Dude... you rock so much... Thank you.