I have 6 workbooks containing around 1300 tabs that I am trying to compile into one consolidated workbook. I'm able to compile three of the six into one new workbook using the move/copy function. The other three workbooks are causing an unidentified error in excel that causes excel to close when I try to use the move/copy funtions. Any help or recomendations regarding how to avoid and or work around this problem would be greatly appriciated. Thank you.