That GUI will have a selector in which person can select an individual workbook. I can use links to file on sharepoint but I rather house them in the one workbook that the GUI is housed in.
You can store multiple worksheets in a single workbook. It is very well possible to let the user select a worksheet from a combo box or list box on a userform.
Storing multiple workbooks in a single workbook makes no sense.
You'd either have to link to the separate workbooks, or move all the sheets from all the workbooks into the workbook with the userform. Excel does not have the concept of a "workbook of workbooks".
You'd either have to link to the separate workbooks, or move all the sheets from all the workbooks into the workbook with the userform. Excel does not have the concept of a "workbook of workbooks".
