merge book1,sheet1,book2,sheet1,book3,sheet1 ect

[cfinch100]

hi
i know this question has been answered a few times,i know this cos i think ive tried every one of them today,i have a userform thats saved onto sheet1of each book,the book is saved as file .xslx obviously book1,2,3,ect.
what i would like to do is just merge sheet1 of all books into one file so i can email the book
please any help getting desperate now
cheers colin
ps\ the data that is on sheet1 is a userform template,the best thing was ive done it before but it added 20 or so extra blank sheets on like sheet1(2) and sheet1(3) ect, i would like to have bk1 sh1 to sh1,bk2 sh1 to sh2 ect hope this explains
all i get from what ive looked at today is screen flicker and macro running but nothing happens