Ranking formula based on values in multiple columns taken from a different sheet

Hello,

I have an issue figuring out a Ranking formula which compares three columns of a different sheet, based on the values in Column A, Column B and Column C. Based on these three values in Col A, B and C, I need to create in a different sheet, a column with the ranking (including the above mentioned columns too).
The Ranking should be based on Column A & then Column B and then Column C.

Your help will be much appreciated.
Thanks in advance.
mt