I am working in a project, what I have to do is let the user choose multiple excel files and then from every single file run a macro that take the information in some specific cells of the files and put that information in a new excel file, all the information that I need have to be in the same sheet of the new excel file. Right now I have two macros that works separated: one for choose and open the excel files and another one to run the macro that take the information, but I need to unified these two and make them just one code. If someone can help me I really appreciate it. First macro: (Code, 50 lines) Second Macro: (Code, 68 lines)