I created a template for customer quotes. I need to e-mail a copy of all quotes to the customer, is there anyway I can copy 1 worksheet from 10-15 Books in the same directory to 1 Workbook with only the values. I want to keep the worksheet layout and I can have 10-15 sheets in the book.