Displaying Message Box For Top Scores In Football Pool

I have a football pool I am doing with my family. I would like a macro that displays a message box that tells me the leaders of the pool using the grand total number. So in my attachment, the message box would say something like:

Sue is in first place with 12 points,
Bob and Dave are in second place with 9 points,
Larry is in third place with 3 points

It doesn't need to be exactly like that, but you get the gist of what I am looking for. The catch here is that the grand total row changes each week as I add games in, so the row moves down every week. I need the macro to stay with the grand total row from week to week.