Consolidating spreadsheets

[WorcesterPark]

Hi
I have around 100 spreadsheets, all saved within 1 folder.
In my consolidation spreadsheet, I'd like to pull the same cell (i.e. B4) from each of the spreadsheets (same sheet title 'Sheet2' in all spreadsheets)
i.e. in consolidation spreadsheet, there will be 100 cells, each linking from B4 of each of the 100 spreadsheets.
Is there a quick way of doing this (without having to go into each of the 100 spreadsheets and separately linking to the consolidation spreadsheet)?
Many thanks!
WP

[FDibbins]

is there any logic/sequence to the file names?

[WorcesterPark]

No - they are called after company names on the whole, so no sequence as such.
Thanks

[FDibbins]

ok, do you have a list of the file names then? what im aiming at, is to create a formula that will reference a list if the file names

[WorcesterPark]

Thanks - the file names are below (there are more, but if you'd advise for these that would be really helpful :-))

Xaxaba
Services UK
OE Services
Central Services
O Holdings SA
JB Ltd
CAB SA
Casa AB
WM Data AS

[jeffreybrown]

Open a blank workbook and in Column A begging with A2 list all of the worksheets (with the extension) and run...

Please Login or Register  to view this content.

[FDibbins]

Jeff's will probably work easier than mine, so I will await you're feedback on his suggestion

[WorcesterPark]

Many thanks both - much appreciated.
Not quite getting the marco to work at the moment - when I input the list of worksheets, I need to do so in format c:/folder/ style?
Thanks
WP

[jeffreybrown]

You can establish the workbook path in this line.

Please Login or Register  to view this content.

If you place the workbook into the same folder with all the other workbooks then you can keep the line above as is.

If you want to establish a different path

Please Login or Register  to view this content.