Thread: Need to combine tons of files to a master file for pivot reporting

Can anyone tell me the easiest way to combine files for a pivot table creation? I need to compile 40 files per week for 13 weeks. Files all of the same type fo information and format, but each file length is different. Hoping someone can direct or supply code for macro automation

Any assistance greatly appreciated