I am trying to write a macro where another worksheet has formulas copied to the active worksheet. Ideally I would like to loop it as well but I need to be able to come back to the first worksheet after referencing the one that has formulas copied from it. Haven't got that far yet.
Here's what I have tried;

Columns("A:A").Select
' did try sheet=activesheet here but gave error
Application.Goto Reference:="R5C1"
Selection.EntireColumn.Hidden = False
Sheets("Training Plan").Select
Columns("A:A").Select
Selection.Copy
Sheets("Skills Last Week").Select This is where I need code making it return to the original sheet instead of just the sheet llisted here
Columns("A:A").Select
ActiveSheet.Paste
Selection.EntireColumn.Hidden = True
End Sub

I might be able to reference it to a list of sheets and loop through those which would be ideal, however I still need to be able to get from the copied sheet to the active one.

Thanks