Combining data from multiple files into one

[dolphn22]

Hi all,

Ever period, our POS report creates a sales file that we can export, but the problem is that it creates one file per store, and I have to manually copy and paste the data from one file to the other to combine them.

My question: Is there a macro I could run that would do this for me? I could keep the file names the same each period if needed. Essentially, is it possible to create a macro to take all of the data in one file and add it to the bottom of another, and repeat with several other files.

I have to admit I am not the best with macros (still learning). If anyone can help here or point in the right direction, it would be greatly appreciated.

Thank You,
Dolphn22

 

[Dryver14]

This is possible,

when you say files do you mean worksheets or workbooks?

 

[dolphn22]

Each file contains one worksheet, ultimately, I want all worksheets combined to one tab on one file. If i'm not making sense, plesae let me know and I will try and explain it better.

Thanks,
dolphn22