Recordset cross referencing spreadsheet data not updating missing values

I have created a recordset to open a spreadsheet (xl1/rs1) and compare certain ranges against the spreadsheet I am running the macro from (xl2/rs2)

If spreadsheet 1 has been worked on I would like spreadsheets 2's columns H:K to be updated to match the info in spreadsheet 1.

The recordset seems to run fine but it doesn't update the second spreadsheet with the values in spreadsheet 1.

If anyone has any ideas why this is happening I would be extremely interested to hear their thoughts on the matter.

I have just stepped into the code attempting to see what happens line by line and I noticed something during the Do until/loop section. In VBA editor in the top right is shows Ln26, Col 1. This only seems to change to Ln26, Ln27, Ln28 & Ln29 (Col 1 stays the same).

Does this mean something, is it not looping all the way through the spreadsheet and is just stuck on these rows hence no values being pulled through?

Ignore this, I've just just realised this is the code lines it is running through (Doh!)

After some investigatiing it would appear that it isn't the case that no values are being selected it appears that values from different lines are being added removing data from spreadsheet 1 and putting the data on different lines (rs2 line 62 is on rs1 line 52 etc).

I think I have created the code to create a list rather than replace the data on specific lines. Anmy ideas how I can make sure the data pulled from rs2 is placed on the corresponding line as rs1?