Music let's see how we can create new excel files from multiple sheets or i would say from each sheet by using vba code here in this file i have multiple sheets one sheet is named as master sheet and all other sheets are saved by month name and i have data on every sheet that is saved by month name so on master sheet i have one command button once i click on this command button then there is vba code that will be executed and save all sheets one by one as new excel file in a specific folder that folder i have on my desktop let me show you that folder so on my desktop i have folder named all files when i open this folder right now i don't have any file in this folder so i'll go to excel file and let me click on this command button so what is happening it is exporting each sheet that is saved by or named by month name and these files are being saved in all files folder so we are getting message task completed let me press ok and let's check that folder if i open this folder now we have all sheets saved as new files with the sheet name if i open one of these files let me open this april file then we can see that data is also saved perfectly so let's see what is the vba code that i have used here and let me explain that vba code i'll go to developer tab click on design mode and then i'll double click on this command button so that i can view the entire code now i have declared one variable dim as integer and then another variable of worksheet type dmws as worksheet and then wb as workbook and then i want to count all the sheets so for that i have used variable a that is of integer time code is a equal to this workbook dot worksheets dot count so it will count all the sheets and then i want to run a for loop for i equal to 1 to a that means it will run for all the sheets that we have in this workbook and then next i and within this for loop i want to escape i don't want to export master sheet so i have started with if condition if this workbook dot worksheet in brackets i dot name is not equal to so this is the sign of not equal to and then in inverted commas master sheet then then what should happen sheet sorry set wb equal to workbooks dot add that means we are avoiding or skipping master sheet if sheet name is not equal to master sheet then we want to add one new workbook and then this workbook dot worksheets we want to copy the active sheet or month sheet and equal to we dot.