want to copy many workbooks into 1 workbook

[april]

i have a folder with over 400 workbooks (1 worksheet per workbook). i want
to copy these workbooks into a single workbook with 400 tabs. is there a
fast way to do this? say a macro?

thanks in advance

 

[Jim Thomlinson]

Check out the copy paste merge examples from Ron's site...

http://www.rondebruin.nl/tips.htm