need help debuging a program that loads data from other excel files

I'm not sure if anyone can help with this but I'll ask anyway. I had a friend help be build this code that opens up other excel files and then imports data from them into this sheet. The code he developed is below. It works fine when I load 11 files which is what its set to now, but I'm trying to get it to open more than 11 now. So far I'll need 20 or 30. As far as I can tell all i have to do is change the "filestoload=10 " to "filestoload=11" or to whatever number of files i want, but when I do it crashes. My friend did notate a lot so I hope it makes sense. I can try to upload an example if needed but I'll have to trim the program down in size so i can upload it. Ill try to do it and post it when i get it done later. There are a lot of lines of code that are ' out but its hard to see in this copy.

Formula:

Please Login or Register  to view this content.

not sure where to put that in what I had. Which one do i replace with that? or do i replace all "for i = 0 to filestoload" with "for i = 0 to Ubound(files)

awesome thanks that worked