Using check boxes to combine workbooks located on a SharePoint site when a button is clicked

  • Hi there,

    The situation I'm in is I have a bunch of excel files located in a folder on a company-wide SharePoint site, and I'm looking to have a master excel file with Macros to select which excel files to combine with checkboxes. When I mean combine I mean take all the workbooks and combine them into one workbook.

    I've attached a picture for reference. The user would first select a few of the checkboxes then when they press "build package", the macro would search the SharePoint site and combine the workbooks that were picked into one master workbook.

    If the whole SharePoint idea isn't possible then can all the files be saved locally and have the same outcome? Is this even possible?

    Thanks for your help in advance!