Importing specific sheet of multiple XLS files into one

[teffstein]

Hello,

I know similar questions have been asked before, but I couldnt work out how it is done.
Basically I have several xls files with the same name, eg. "test" with an alternating number at the end. 1 - ....
each of these workbooks contain several sheets but all books are the same just with different information on it. each workbook has got a summary sheet in it, i want to import all summary sheets into a single workbook called summary. but each sheet should be imported as in individual sheet, if that makes sense?
Can anyone help me?
thanks

 

[Krishnakumar]

Did you replace the path with your path ?

 

[Krishnakumar]

thanks again... your code works perfect. was my own stupidity...
i forgot a '\' in my filepath... stupid me...
things happen if you been working for too long...
thanks again for the help... absolutly superb...

Glad you find it yourself.

 

[teffstein]

thanks again... your code works perfect. was my own stupidity...
i forgot a '\' in my filepath... stupid me...
things happen if you been working for too long...
thanks again for the help... absolutly superb...

thanks again

 

[quallerd]

I see that this is an old thread, but am hoping that somebody is still tracking it. I am trying to perform a similiar function to the original poster. The code above works perfectly - almost! Thanks BTW for getting me that far!!! The problem I am having now is with updating the worksheets that had been previously imported into the Master (i.e. Summary) workbook. The original import works fine. Any newly named files also work fine. However, new data in a workbook that had been previously imported does not come through. Any help will be greatly appreciated!!!