Return source/delivery sites from different files

Hi all,

I hope you are well! This is my first message in this forum, I hope I can learn a lot from you guys!!

I am seeking for some help for a project I would like to do.
I work in a Logistics company and at the moment we have different excel files where we keep some rates (from point X to point Y, price is Z).
The thing is that we have like 10/12 different Excel files (each one for different countries, for example UK to Germany, UK to France, which we keep updating as we get new ones), and inside of these files we multitude of rates

I would like to create an excel where by typing: Location site, and delivery site, it would pull out the price inmediately, rather going inside each file and look for it.

I've tried with the forumla "search" and "pull data", but I can't seem to make it work.
I am not sure if all this makes sense.

I would appreciate if someone could give me a hand! Many thanks guys!
Have a lovely evening!

Moderator note: Please review forum rules regarding thread titles. As a courtesy I have taken the liberty of changing your thread title to something more descriptive this time.