VBA Excel宏将一列复制到另一个工作簿中

I have 2 workbooks and am trying to find a way to copy a column from wb1 into wb2. I am aware I could just copy/paste, but the idea is to make something so my boss can click the macro and everything populates. I have 2 workbooks and am trying to find a way