The issue I have is, I have 9 Excel Files that shared with multiple users. All of these workbook and sheets fully protected. Each workbook has 30 sheets and conditional formatting. I have a master file that exactly identical to these sheet. [ basically this master file has 30 sheets with the same formatting]. How could I combine all these 9 file to my Master File/ Consolidated File? [All the Sheet 1 information (from the non consolidated files) need to go to Sheet 1 in the consolidated file.] Appreciate your help