I think that you will need a macro for this since a formula can only 'pull' data, it can't 'push'.
Will the total always be in A50?
Eventually you will run out of columns on the sheet that the data is copied to. What should happen then?
Dell XPS 13 9370 (2018) review
The art of 'British' pulp fiction
Best password managers for Mac
TV & streaming : comment regarder le Tournoi des Six Nations 2018 ?