importing file names

[Sheila]

I need to know how to set up a workbook so that I can list each file
name in a specific folder in cell a1:A?, also I need to put the oinfo
from say Cell B1 in those workbooks into B1 in the sheet I am using to
summarise, same also for info in cell C1.

I dont mind if this is completed as the workbook opens or if I have to
click a button to make it happen, so long as it happens. The only
files in the folder (say c:\Jobs\*.*) are Excel workbooks.

Hope someone can help.

Sheila
TIA

 

[Sheila]

That wasnt really clear was it, sorry, all the workbooks in the folder
only have one sheet in them, I should of said that, sorry. Would also
be good too if the file name that is entered, DIDNT have the .xls at
the end of it.

thanks again
sheila