Never written a VBA-need all changes on one worksheet to duplicate in another

I have a large master worksheet, each tab is a separate "store" P & L that is updated each week. Columns are added, formulas are changed, columns are hidden, etc. I need to create individual workbooks that will have several "store" tabs from the master and then a summary tab for each district manager. I need to have the tabs in the district manager worksheet to update each week so I am not worrying about adding columns and what not. I currently have 33 stores so this is really important. Thanks for any help.

Hi, welcome to the forum

Probably the best thing to do here is upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

As another suggestion, if you Group all your sheets (click the 1st tab, hold ALT and click the last tab), everything you do to 1 sheet, will be "punched" through to all the other sheets...insert a new column after H, they all get the new column...type ABC into A1, all sheets will have ABC in A1. When done, click on a non-grouped cell, or rt-click a tab and click Ungroup

Hi,

I urge you to create a master 2D 'flat file' database in which you record everything, with one row per record. Once you've done that then you will have satabase against which you can easily produce reports or Pivot Tables to analyse your data every which way.

Do not have separate tabs for each store. Simply record the store name/reference in an additional column in the database