how to auto populate data from multiple sheets to a master

Hi guys

Been struggling with this and don't know where to start. Any suggestions would be helpful.

Im trying to create a master report which will be used to send out daily. The problem is everyday there is new data for each of the headings and instead of copy and pasting each new data for the day i would like it to automatically be auto populated to the master report.

Is there any way to do this using coding instead of linking?

Thanks in advance