Copy a cell value where that cell is found relative to another cell.

[briandeasycorkcityie]

I am looking to populate a summary sheet from a series of sheets within the same workbook.

The above image is the summary sheet. Each Sheet within the workbook has a summary block but the vertical location may differ in each sheet. I am looking to scan all sheets to find the relevant cell and copy the link the values in the summary sheet back to each sheet.

The cell on each Sheet can be found by locating the text string in row 30 and then choosing cell L on that row. The same for the four rows from 30 to 33.

Could someone help with this please?

 

[mumps]

Do the sheet names correspond to the Services listed in the Summary sheet? It is hard to work with pictures. It would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach screenshots (not pictures) of your summary sheet and at least one of the other sheets. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).