I wondered why an item from the tabs was being copied twice..... now I know.


Fixed this in the macro of the hidden BLANK sheet, will exist for sheets created from now on.

Did the changes to B39 and K27.
For any changed you want to appear on all sheets ---> unhide the BLANK sheet ---> make the changes and hide the sheet again. It won't do anything to the existing tabs but from then on all sheets created from the BLANK will include those changes.
The thing to watch here though is if you change a cell to a formula that is being copied to the summary it won't copy over without altering the macro to accommodate it.

I don't know how to do this in a manner that just "looks after itself", so had to put a button on the summary sheet to handle it.
I've used summary column A to hold the sheet index (ie:sheet location in the tab lineup) and then sorted based on that.

Think this should look after everything you've mentioned.
Be sure to mark this thread as solved when you think it is.
Thanks.

Attached Files

5-12-15 Sample_3.xlsm (98.8 KB, 10 views)