Hi,

To move ahead, why don't you turn on your macro recorder and go through your usual process (with your master workbook and one of your files) in order to visualize the way VBA is going to code your actions ...

Then will come the time of expanding this one-file routine to all the files you have in your list ...