You may find that a pivot table will do the job using the option
"Muliple Consolidation Ranges".

You would probably have to hide sheets rather than have them deleted.
This way you could make one workbook & then copy.


---
Message posted from http://www.ExcelForum.com/