Grouping worksheets from individual files into a master workbook

[splash]

Hi all

I have an issue that I would be very appreciative of your help with:

I have a large number of excel files with a standard worksheet in a standard layout. These workbooks are saved in a number of folders within a network drive - is there a means to extract the information (numbers, format, layout etc) into a number of worksheets within a consolidated workbook - without doing this manually?

Any assistance with this would be very much appreciated

Thanks a lot in advance
Splash