Just change the “Location” in the List Files node and this will work fine for you if the value you are looking for is in G20 cell in all files. Your example Excel files had nothing in G20 for 2 first files so I modified them to be the same as the third file which has the exchange rate in cell G20.
The url variable is passed from the Table Row To Variable Loop Start node to the Excel Reader node.
In the configuration window of the reader node uncheck the “Read entire data sheet, or …” option and input the cell column and row:
I extracted the file name using regex in String Manipulation but it seems easier to use URL to File Path (Variable) used by @ScottF. The Constant Value Column adds the file name.
The Column Rename and Resorter nodes to make everything clean.