I didn't see Sintek's reply until I came here to update the thread. I will try those and see if they work.

However, I also found something else and wanted to see if anyone had worked with this solution. Chip Pearson published an Import/Export module. I am able to export all the files fine. However, the import part is not working properly. I have used both of his install spreadsheets, ran Excel as an administrator while running both spreadsheets, enabled the "Trust access to the VBA project model", and am still unable to use the multi-import function. I see it in the menu, but clicking on it does nothing. I have called Chip (he has his number posted on his website), as well as sent some emails. I have not heard back in a week. It looks like this module was made a while ago, so I'm not sure it will work with Excel 2016. Has anyone gotten these to work?