Importing multiple worsheets into one workbook

[SewerUrchin]

Folks:

I have a status sheet workbook, that saves under each person's name concatenated to the month. All direct reports drop their workbook file into a directory that only their supervisor has access to. At the end of the month, I want to create a worksheet that, using a button, opens an import dialogue box. This then allows the supervisor to pull in exactly the data they want to see. Once the supervisor says "Ok," the system then pulls in each file specified as a new worksheet in the supervisor workbook.

I have looked and searched this site for an answer and there is only an answer for pulling in one file and not multiples or not through using a dialogue box that allows the user to define the files being pulled in. I'm betting I'm just too new at doing this and the answer is so basic, I'm missing it. Any thoughts for the newbie treading in water he probably shouldn't be treading in?

Thanks!