Hold the ctrl key and click on the sheet tabs on which you want to Enter the data. Start entering your data and do formatting. Now check the Sheets which you have selected. Your data has been entered in all the sheets you have selected with the formatting.