Macro to delimit and compile multiple files to one sheet:

Thanks for the tip, I attached the two files below. The excel sheet is where I'd like to compile the data into, on the second tab. The zip folder contains one of the reports being downloaded daily. I'd like to be able to use a macro that opens/delimits/and imports the data from multiple reports at the following location: \\10.6.1.129\exports\LUNLEV

Thanks again for the quick replies.


BELL.zip STOCKOUT TRACKER.xlsx