Have you considered using Data/Consolidation? With this you can
consolidate data from multiple spreadsheets into a single spreadsheet.
--
humejap
------------------------------------------------------------------------
humejap's Profile:
http://www.excelforum.com/member.php...fo&userid=5506
View this thread:
http://www.excelforum.com/showthread...hreadid=394907