Copy information from one to other worksheet

Hi I am new in making macro.

I don’t know how to do this (for the example):

I have 30+ worksheets and in the last worksheet are data which I want to copy in all other worksheets.

First I would like to select information in cell "C2" in first worksheet and then I would like to find this information in the last worksheet. When I would found this information in the last worksheet I would like to copy cell right from that information (for the example: If the information from c
"C2" in the first worksheet is in the cell "B15" in the last worksheet I would like to copy information which is in the cell "C15") back to the first worksheet in cell C24 (for the example).

So, I would like to repeat this process for all 30+ worksheets.

Can someone help me please.

I found soulution with function VLOOKUP.

Thanks

Assuming all the values to check are in C2 of each sheet, the last sheet name is something specific like "Database", and found items copy back to cell C24 of each sheet, something like this would do it:

Option Explicit

Sub UpdateFromDatabase()
Dim wsDB As Worksheet, ws As Worksheet
Dim vFIND As Range

Set wsDB = Sheets("Database")

On Error Resume Next
For Each ws In Worksheets
    If ws.Name <> wsDB.Name Then
        Set vFIND = wsDB.Range("B:B").Find(ws.Range("C2").Value, LookIn:=xlValues, LookAt:=xlWhole)   'xlPart for partial matches
        If Not vFIND Is Nothing Then
            ws.Range("C24").Value = wsDB.Range("C" & vFIND.Row).Value
            Set vFIND = Nothing
        End If
    End If
Next ws

End Sub