Comparing Across Worksheets
 

Hello

I have a workbook with 10 worksheets in it. The first worksheet is a summary of the other 9 identically formatted sheets. So in worksheets 2 thru 10 the columns are named: Source (Column A), Day(Column B), Month (Column C), Year(Col D). In Sheet 1 I have the min, max and avg values from sheets 2-10 for Day, Month and Year (Columns B -J)

My question is how do I return the worksheet name with the coresponding max value for the Day, Month and Year? The worksheets are labeled with different names and I wanted to place the max number directly next to a name on the summary page

I've tried several functions - Match, Lookup, etc. which I couldn't get to work

Thank you for your help in advance!