Lookup some data from an Share point Excel file

Hi Pals,

Please I asked to work on a project to pull data from multiple excel files saved on a Share point site which they are in respective folders. I am wondering how I can lookup these data from these sites. Thanks for the assistance in advance.