Link and Automate(update) Template with data from different spreadsheets

Hi All

I have this project for my uni and I just cannot get it right...the assignment needs to be done by this WED and I am stressing out.

I have never done this before and the materials that they teach us don't seem to help, strangely enough.


What I need to do is this:

I have been given a few spreadsheets,each with a carrier name and various tabs with rates for FTL (full truck load) and LTL (less than truck load) per country.

For ex. Carrier C : Tab 1 Ukraine FTL rates,Tab 2 Austria FTL rates, etc. Each of these tabs has the rates for a few truck load sizes and postcodes.

I need to automate a separate sheet (I call it a template) with the lowest rate for each country, per each size and postcode.

Basically, my table should look to all these carrier`s spreadsheets and get the lowest rate for each postcode and load size, including the name of the corresponding carrier. If one of the rates changes my template should automatically update. ( The carrier sheet does not change its name or format).

I have attached the spreadsheets for easier understanding, I believe it sounds more complicated than it is..as long as you know what you are doing.

Can you please have a look and help? Oh, you can change and modify my template to suit the solution..the table(s) can look either way as long as it accommodates all the answers...

Much appreciate any help you can provide..

Thank you,
Ana

I guess it is too big of a job...as I am running out of time,anyone willing to help if I add this on the Commercial Services forum and pay for your service??