Cell Value equals sheet name..Help Please

I have multiple sheets in a workbook and i am trying to do the following
if value in column G from sheet 1 = sheet names, then copy value from A2 from that sheet to R2 of Sheet 1
so far i have this and i'm stuck..please help...thanks

Please Login or Register  to view this content.

You might need to loop twice, that is for each cell and each sheet.

Please Login or Register  to view this content.

Originally Posted by AB33

You might need to loop twice, that is for each cell and each sheet.

Please Login or Register  to view this content.

Thanks AB33