Pull data from another excel document

[Sagar29061]

I have 2 excel documents (not work sheets). ABC.xls, PQR.xls and XYZ.xls. 

I want to automatically pull the data from ABC and PQR to XYZ. Is there any way?

All three documents are saved in same share point location in my computer.

Unfortunately, i cannot make it as multiple sheets in same document. 

Can it be done by Power BI?

[#2]

If you are pulling similarly shaped data (for instance, a table in both files with the same columns), then you can use Data, Get Data, From File, From Folder to do this. See https://support.microsoft.com/en-us/office/import-data-from-a-folder-with-multiple-files-power-query...