Selecting Files from workbook

[lockye]

I have a master sheet that display’s all workbooks in a certain folder. Column A displays the file name. I would like to be able to have a select button next to the list of files that are generated.

When the file or files are selected parts of those workbooks will be copied into separate pages the master sheet.

I will then create a template to work with this data.

Any help would be appreciated