Thank you...is there a way to execute this macro without it opening each state file? It seems to want to open each file prior to pasting in the new sheet.