What exactly do you need help with?
If it's to make sure data is read from/written to the correct worksheet all you need to do is make sure you reference the correct worksheet in the code.
For example, here you have no worksheet reference so the code will be referring to the active sheet.
If you wanted to refer to the worksheet 'OE' you would use this.
Note I've changed xlDown to xlUp, because you can't go down from the last row in the worksheet.
Using xlUp will come from the bottom up and will find the last row with data in column A.
Bookmarks