Optimizing multiple sheet workbook

Hello,

I have 10 large data worksheets that I want to analyze in the same way. However, the problem is when I want to change a formula on 1 worksheet / spacing / order of columns. Then, I have to do it 10 times, once on each worksheet.

Is there a way to create a "template" formula sheet, have 10 sheets with data, and to generate 10 data sheets all based on my "template" sheet so that when I modify something in my "template" sheet it is propagated to all sheets?

Thanks,
Shawn

Are you familiar with Sheet Grouping?

You can group any number of sheets and while grouped ANY action performed on one sheet within the group will be performed on all sheets within the group.