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.
Regards