Multiple sheet, find, copy specific cell and paste

Hello, i have a challenge for you.

Im working on a doccument to pull information from a different sheet, that was imported from a web based human machine interface. Here lies my problems....

A simple copy past will not work because the rows of data changes depending on the amount of information captured by the HMI.



B8 is where im starting, i need to import, or copy the zone1 temperature from a corresponding doccument.

This doccument looks like this....

The part i cant figure out is the data is not always in the same cell location. I tried a search find function to look for "Zone1" in cell E10 but cannot figure out for to get it to copy the information from the cell L10 that i need.

The code i tried is

="Zone1 "IF (OR (ISNUMBER (SEARCH("Zone1",RC [7],10)),

I need the text "Zone1" with the formula after.

The L column will always have the information i need bjt the row can change.

Im at a mental loss any help would be awsome!!

Thank you