Macro to select which workbook you want to copy data from

[ianmurray]

I want to automate pasting data from one workbook to my into my workbook however the workbook name i copy from will change every time since its updated daily. The columns i copy from will not change and the columns of my workbook i paste into will be static as well. There are several columns i would like to copy paste from which would save me time.

So basically i would like to create a button that asks you for the file name, and i want to create another button to copy paste the data from same columns into my workbook everytime. Would that be possible

 

[ianmurray]

I am trying to link two files by clicking a button and selecting the file and then copy pasting columns from that linked file into my file.