So Iβm trying to write 10 to the 10 series sheet and 20 to the 20 series sheet.

Sheet name works fine, I get two sheets.

However the string that goes into the data appears in TWO cells.

So 10 appears on sheet 10 series but 1 is in cell A5 and 0 is in cell A6.

20 appears on sheet 20 series but 2 is in cell B5 and 0 is in cell B6.

I want 10 to be in A5 only on the 10 series sheet and for 20 to be in B5 only on the 20 series sheet.