Does your first workbook (the one with the Encoding sheet in it) just
have its values overwritten each day, or do you keep the previous day's
workbook (i.e. do you have a Monday, Tuesday Wednesday etc workbook?) ?

In your WE sheets, will you have your sets of data in columns A/B, C/D,
E/F, G/H, I/J, or do you have blank columns between? What row in these
sheets do you want the data from the Encoding worksheet to start? (Same
rows, 6 - 23 ?)

Can you arrange to have both workbooks open at the same time?

Pete