Data is entered into the main DATA sheet.

But i want most of my work to happen on the analysis sheet. Here most of the colums arent relevant, so i would hide them and use the relevant columns for analysis.

Is there anyway to duplicate the data worksheet. with live updating, or maybe with an event everytime i activate my analysis sheet. And copied with a reference so that if there is any change in the data, it changes in the analysis sheet too.