how to delete extra sheets in workbook

[cfinch100]

hi
i have just managed to combine 8 books into one sheet ,a feat for me ,anyway now the master book has lots of duplicate sheets ie sheets2(8),sheets3(9)ect
i just want all sheets 1 to be populated in this book ,not bothered if its named sheet1, sheet2 ect can be as is sheet1(1),sheet1(2),have tried to delete all empty sheets but it deletes all of them
any suggestions would be good


this is code used to get sheet1 from book1 to book8 but next batch could only have book1 to book4 only sheet1 will be copied always its just that it ends up multiple sheets

cheers colin

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[cfinch100]

hi john
thanks for reply first
i now have 124 sheets with my 8 files spread in between them say,no 124 is file then 119 is another ect in between are blanks ,have tried to delete all empty sheets but all delete bar one,any ideas
cheers colin
ps it was 8 books into one book not files as i said earlier sorry dont no files from books