Extract cells from series of spreadsheets to one summary spreadsheet/database

[Richiejjj]

A company I have just joined has a series of spreadsheets in individual workbooks which it uses as a costing document, there are quite a lot of cells involved such as company name, date, originator, hours, cost, equipment, etc, etc.

I want to end up with a new spreadsheet that summaries the contents of each of the other workbooks with column headings and then a row for each 'imported' spreadsheet.

Is there any other way other than manually entering?

Thanks
R