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?
OnePlus 5 review
Alice Saey's mesmerising animation for Dutch singer Mark Lotterman
iPad Pro 10.5in (2017) review
Comment booster votre iPhone ?