Hello,

I am struggling to have a macro so that it should lookup the sheet name with the range of colums in a summary sheet and then copy and paste the reference value in the matching sheet.

Let me explain the situation in detail.....

I have a workbook which has 120 worksheets. Sheet1 i.e., summary sheet has all the sheet names in colum A and the reference value in colum B. I am in need of a macro with which it should lookup the sheet name with the names available in colum A and copy & Paste the reference value from colum B in the matching sheet's cell "C1".

Please somebody help me in getting this macro, I would appreciate the help. Thank you in advance.