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:

Please Login or Register  to view this content.