Importing data and automatic updating

[hopeful_positive]

Hello all,

Thank you for all your help in advance.

I am an intermediate user of excel - no coding background - but pretty good analytically.

I am working with 10 production lines with each operator recording data for each shift. 3 shifts in a day. 30 files of data for each day. There is a folder for each line within which there are 3 files for each shift.

I would like to transfer a certain range of data from each of the 30 files into another file (destination file located elsewhere on the laptop) without having to open the raw data files. Is there a VBA code and/or macro that I can use to accomplish this? I am hoping to create a button (in the destination file) with a macro behind it so that once I click on it, it will copy and paste the data from the raw files containing data from the previous day into the destination file.

The destination file will process this data to generate some meaningful information and trends. The destination file has formulas already in place so that once the data is pasted, it will process all of it.

I sincerely appreciate all your effort and help.

Thank you