How do you create a button that picks up 7 workbooks and sucks them each individually into 7 different tables?

I have a work book which is a questionaire. When i click a prepare button it creates 7 different workbooks and saves them individually to the desktop. Now I need to bring these workbooks to there respected tbales in mt DB. Workbook names will ALWAYS be the same as the tables name.

I have tried using saved import process macros etc. Works well on MY pc, But not others because the saved import is restricted to my pc file pathway.

My question is how do i create the code to allow what i want to work?