Macro to combine several excel files

I have 30 or so excel files, each has one sheet called "O10" with a variable number of rows but the same name and number of columns. All of the files are saved in one folder "C:Temp" and I would like to run a macro in a blank workbook that will take the data from all of the files and merge it into one sheet within one file. I have looked around the internet and found several solutions posted but can't seem to get any of them to work with various errors, this might be because I am using Excel 2010, or perhaps because none of the 30 files are macro enabled, I would appreciate any help with getting a code to solve my issue. Thank you!

Perhaps a macro like this would be of help?

Please Login or Register  to view this content.

This will extract info only from files ending with ".xlsx"

Alf

Thanks Alf, I pasted the code in and although when the code is run it doesn't kick out an error it also doesn't result in the desired outcome, my new workbook that i opened and pasted the code in which is meant to accumulate results remains blank even after the macro ran

Rerading your description of the problem you say

each has one sheet called "O10"

so I now realise that each file have several worksheets. So change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

and see if that works better.

Alf

may i get code for combine many excel to 1 excel and can i use this code for this situation?