Formula OFFSET from different sheet

I am not sure if OFFSET is the correct formula. I am returning a #VALUE error.

For the month of April (Row 6) I want to know which years have had the biggest profit. I do this in the yellow box (the one with the red circle around it) with this formula =MAX('CC Yearly Sales'!C6:E6,1). I then do the same for the 2nd and 3rd biggest years as shown above.

My error is occurring when I then want to see the year the top 3 figures are.

This is the formula I am using. =OFFSET(MAX('CC Yearly Sales'!C6:E6,1)),-4,0)

I think I am way off... I would love some help if anyone can solve my problem I would be so grateful!