I am trying to build a macro that allows a user to input the excel file name
in certain filepath. The macro then should import that file into this
workbook in the same format. I am thinking of having some kind of drop down
menu box that will help user pick the file that he/she wants to import and
then as soon as he clicks the file name the macro imports that file in the
same format by inserting a new worksheet. Is this possible? Please help.