Good Afternoon.

I'm trying to create a code that displays the maximum value from column A and it's adjacent value from column B, from each worksheet.

I have sheet1 as my collection sheet. All the other sheets are named referenced to it's file name.

I would like the code to be able to collect the data from each tab and display the values in a list on sheet1.

Any help would be much appreciated.