Formula to look up last cell in column on a different sheet

Hello all!

I am trying to create a master sheet that pulls in information from other sheets in my workbook. Currently, I need a formula to pull in/look up the last cell in the column on a different sheet in the workbook. I always want the last cell with data in one specific column to pull into my Master sheet. In each sheet I have several columns with information so I cannot simply use a generic formula for the entire sheet. There will never be any blank cells without data. All the cells will have numerical values and no words. Here is an example of what I am working with and the final goal.

Sheet2

Column A
AAA
DDD
GGG
JJJ

Column B
BBB
EEE
HHH
LLL

Column C
CCC
FFF
III
MMM


I want data from MMM to appear in my Master sheet.

If you can understand me and could help I will greatly appreciate it!

Thanks for your time!

To be clear: even though you post showed only LETTERS and NO numbers in every cell, your real data contains only NUMBERS?????

I think that you need VBA to do this. Is that OK with you?? Not sure if my VBA is up to it, but I'll try!!

Try this out...

Sub Method2()
    Dim ws As Worksheet
    Dim rng1 As Range
    Set ws = Sheets("Sheet1")
    Set rng1 = ws.Columns("A:Z").Find("*", ws.[a1], xlValues, , xlByRows, xlPrevious)
    If Not rng1 Is Nothing Then
        MsgBox "The value in the last cell is " & rng1.Value
    Else
        MsgBox ws.Name & " columns A:Z are empty", vbCritical
    End If
End Sub