Is the copying of information from the closed workbooks working?
If so, on which sheets do you want to run the code I supplied?
By the looks of it, not on all sheets like the code is designed to do.
If you have all the copying, pasting, deleting columns etc done, run the code on the sheets that need it only.