Formula to return the lowest value in differents tables

Hi !

I need to create a formula and I'm not sure which function would be best for that.

Basically I have different tables with the same products, with prices and other data (they are different suppliers).

Now I would like to have a formula that will check for the lowest price (a column) for a specific product (a column as well, all the different tables have the same values in this column) in all the different tables and return a value (maybe the name of the table, but the lowest price itself might be quite easier).

Which function would be best for this ?

Thanks !