I am new to Visual Basic, so sorry if this is an extremely simple question.

What I want to do is create code that will prompt the user to choose an Excel file to import data from, and have this data copied to a newly created tab in another Excel file.

In other words, the user will already have an Excel file opened, and will click on a button that says something like "Click here to import new data." This will open a Windows Explorer window from which they will choose the file containing the desired information. The values contained in the selected file will be imported into a newly-created tab in the Excel spreadsheet that is already open. Preferably, the tab will have the same name as the file name from which the data is imported (i.e. the tab will be called "Q1 Revenue" if they choose "Q1 Revenue.xls" to import from.)

Thanks for the help.