Needing ideas on how to do this

[Guest]

I am trying to create a method to compare pricing on 2 products from 4 sources.
Here is what I'm thinking but am not sure if the thinking is right here is
how I'm thinking of proceeding:

1. The label of the 4 columns changes so I need to try to determine the
value of each column before comparing highest price.
2. I want to copy the 10 values and paste them into a result table.
3. Compare a value in each of the 4 tables and paste the highest value in
the result table.

I am trying to produce this output table daily thus I think I need to add
some functions into the work sheet?

Any ideas?

Thank you in advance

 

[Dave D-C]

I am trying to create a method to compare pricing on 2 products from 4 sources.
Here is what I'm thinking but am not sure if the thinking is right here is
how I'm thinking of proceeding:
1. The label of the 4 columns changes so I need to try to determine the
value of each column before comparing highest price.
2. I want to copy the 10 values and paste them into a result table.
3. Compare a value in each of the 4 tables and paste the highest value in
the result table.
I am trying to produce this output table daily thus I think I need to add
some functions into the work sheet?

.. 2 products from 4 sources .. the 10 values ..

Seems like you need only multiple =MAX(range) functions.