Dynamic selection of worksheets for copy to new workbook

Hi,

I have a several workbooks which I want to copy all tabs (except the last 2-tabs) to a new workbook. However, each of the workbooks tabs is uniquely named. I have attempted to extract the tab names and concatenate to a variable, to be used in an array, but this is not working.

Is there a simpler method to accomplish this ?.. My current sheet select/copy code is below to give you the concept of what I am trying to accomplish.

Please Login or Register  to view this content.

Thanks for any assistance you can provide

jay in Calif