Not sure I understand.
You want a macro that deletes all data on anything other than the master sheet then redistributes it all again?
And you want that process instead of which above?

BSB