Get Data (Excel) From a folder

Morning everybody! Refer to the subject, i don't really know how to get data (efficient way) from a folder. Below i will give an example;   First step.   This is the location of the ...