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

[rw9275]

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.