If you use your experience of recording macros, you will probably be
able to generate the code for transferring one of the 200+ spreadsheets
to the new one (chose a complex one with several sheets). Adapting this,
you could put it into a loop reading from a list of all the 200+ files
which are opened and closed sequentially. The workbook on my download
page can produce the list for you if the spreadsheets are in the same
folder structure.


--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile: http://www.excelforum.com/member.php...o&userid=10931
View this thread: http://www.excelforum.com/showthread...hreadid=546486