Macro to choose the max x value and

I'll just warn here, that I suck at VBA. Every macro I write is done brute force. When I totally get stuck I end up here. So here my process of trying to build what you need. I'd like to help more, but this is the best I can offer.

Record a macro of:

open a new worksheet
select a cell and type in: =max(
then select the values on the first worksheet you are interested in
Then type: ) and hit enter
Then I would select the next row down and do it again so you can see how excel references groups of six cells

stop your macro recording

now go find our about ranges and how to utilize them properly
I use this link a lot the get range syntax
http://www.excel-vba.com/vba-excel-lesson-2-6-1-range-cells.­htm

Then learn how to do a for statement (you can just type: for and then hit f1 to get help on it in the VBA editor)
this link has an example of a FOR statement
http://www.excel-vba.com/vba-code-2-11-variables.htm

and more stuff here
http://www.excel-vba.com/excel-vba-contents.htm

There are other sites, i generally google what I need.

I find that working it out for myself help me learn the whole VBA faster than just asking question after question.

I know I have not been as helpful as you need, but I find the turnaround on this forum to be slower than I need, so I thought I'd give you a method to work it out on your own.