Worksheet creation triggers addition of data to master sheet??

Vague subject line I line....anyway I have this "master" worksheet that I want to display data that is pulled from other sheets (ie:sheet2!E4) etc. Basically the other sheets are raw data that hold times of specific tests run on a web app. I average the times in the sheets and those numbers are displayed on the master sheet for analysis.

What I want to do is whenever I add a new sheet to the document, I would like excel to auto populate the mastersheet with the correct format and correct cell/sheet reference according to the newly created sheets name. See pic for clarification.
I don't even know if this is possible; I've googled and haven't found what I needed.

Thanks