web data capture problem

[gsdanger]

Good Day all,
I copy and paste static australian horse racing form from sky racing.com.au into my excel spreadsheet. I then use the cell addresses within this spreadsheet to populate another sheet with formulas, to analyse the recent form of each horse.
The problem is, the source web page occasionally add a row or delete a row, which kills all my formulas in my second sheet (original cell references become incorrect).
Is there a way to ensure I can get the correct data from the first spreadsheet, even though the original cell reference may be incorrect?
I need expert assistance please.

Kind Regards.
gsdanger

 

[Anthony47]

Maybe you need to use VLOOKUP to find the row the data should be fetched from

 

[gsdanger]

Maybe you need to use VLOOKUP to find the row the data should be fetched from

Thanks Anthony47, I will fiddle with the lookup options and hopefully will be able to progress using this option.
Thank you for your input.
Regards...gsdanger

 

[Anthony47]

If you publish the layout of the data in Sheet1 and Sheet2 (a picture should be enough) maybe we can suggest a formula