Trying to create a dynamic sales report

Hi I am trying to create a dynamic sales report, so that I dont have to manually enter so much.   1) I will have a master sheet where I enter the sale information in each row.   example of sheet ...