I'm needing to copy a bunch of information from a bunch of different excel
files into one massive workbook. I'm hoping to avoid having to do that
manually. I already tried a macro, but it seems as if macros don't work
across multiple files. I don't need to copy all of the information over, but
rather information in specific cells. The information is in different
worksheets in the files. Does anyone know of anything I could do to make this
easier?