Dear All,

First of all, I hope you are all well and safe on these turbulent times.

Sorry If I do not have and sample files as I did not started to build a dashboard.

I will have few files stored in a folder. All files will be identical in terms of headers and tables, only the information updated within tables and some cells will be different as this will be individual files per customer/employee.

The thing I am not sure how to do, if possible, is to have a Master file that will copy all the files information from that folder. Now, the folder might have 3 excel files or 10 or 12 and so on.

Like I’ve mentioned, each file is per customer information.

I need a code that opens every individual file from a specific folder (e.g. c:\Users\Customers), copy the required information to the Master file and closes the source file(s). No need to input data from source files, just retrieve it.

Any suggestion will be highly appreciated.

Best regards and stay safe!
Filipe