Hello

I'm trying to use this macro to copy multiple sheets from multiple files. I have the files sales2010.xls, sales 2009.xls, sales 2008.xls. each contianing the sheet "sales". I would like to copy them into a new files with sheet names sales09, sales10,...

any sugestions?

thanks!


Admin edit: Moved from thread, referenced here: http://www.vbaexpress.com/forum/showthread.php?t=7003