Hello,
I have a folder with several excel files (i.e. A.xls, B.xls, C.xls ...) and I want to create a macro that depending on the text in a determinate cell (A, B, C,...), the macro copy all the worksheets from this file to the current workbook. I want to copy them after the current worksheet. I also want that when you change the text in the cell (i.e. for example from A to B) the macro eliminates all the worksheets from the file A and copy the worksheets from file B.
Thank you!