copy sheets and files

[eran3185]

hi

i build a macro that take al the sheets and copy in a new sheet.
it also put the aheet name at the first row.
then i build a loop that take all the files and do the same thing.
the problems :
1 the loop of the files dont stop ...
2 i want that the sheet name will be at the last column and all over

[anandbohra]

http://www.theofficeexperts.com/foru...ead.php?t=8426

[eran3185]

with all the respect , i dont know what u want
may be there is a someone who can help me ?