I am trying to create a macro in file A that will ask the user to locate a
different file (name of file will change) and then ask which sheet from
stated file needs to be imported into file A and then name that "Imported".
Any help would greatly be appreciated.