I want to append to this macro below so that it will know to paste data into a column that I just inserted in worksheet “Count”. In the macro below I put Column G, but the new column I insert won’t always be Column G. In other words, assume I just inserted a new column in worksheet “Count”. I would like to make the macro know to paste what I copied from worksheet “Number” into Rows 4:20 of that new Column in worksheet “Count” whatever column it may be. Can you assist me with this?

Sub FindColumn()
Sheets("Number").Activate
Range("E4:E20").Copy
Sheets("Count").Activate
Range("G4:G20").PasteSpecial Paste:=xlPasteValues, _
Operation:=xlNone, SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
Application.ScreenUpdating = True
End Sub