Try this, as I do this all of the time.
Bring up a brand new Excel Workbook.

Select ( Tools ) from command bar line.
Select the ( Macro ) item and then in adjacent panel, select the listed ( Macros
) item.
This will display a (Macro Name) panel, because there are no existing
(Modules/Macros) in the workbook.
Enter in any MacroName ( sample ) and select ( Create ), so you can enter into
the VB Editor.
This will bring up the VBE for VBA Programming&Coding section of the workbook.

As a result, you will see a new module created as ( Module1 ), which you can
highlight(right-click) and ( Remove ) it.
After doing so, you can goto the ( File ) command bar button  and select the (
Import ) item.
This will display the Import Panel, where you would speccify the
directory/folder source for the ( Modules ) & ( UserForms ).
You have to do a single file Import for each module and for each userform,
unless somebody knows how to do all in one single step.