Creating Daily report

Hey guys i know little about the excel and i was trying to learn more cause i need to make a sales report for my store and expense report in one work book
but i wanted plugin the numbers daily sales report in to main page but add that report to the monthly report and the check pay out table have the selection from the list of Check pay out work sheet and when i plugin the number in that table it would add them to the check pay out work sheet

so can someone please help me out
i will attach my workbook to the post
i have read some book but i could not find anything on it
and i dont know much about the VBA at allreport.xlsx

i tried to attach the file to post but i guess it did not get attched to it
i will try attach it again

I have attached the file with formula i need to be done
What i need is that when i plug in the number in daily report which are i need those number go to the Monthly report and clear the cell after i submit them
and them it will update the MTD cells after that
and the number in the blue should update the Balance sheet worksheet
and the the Check Pay Out i want to load the table from the Check Pay Out sheet and them select them a from and list and when i plugin in the number this will update the Check Pay Out sheet and clear the table after i Submit them this should happen after all the calculation are done and plugged all the number in the cell i need
i was trying to create like a template for it so i dont have to create one for each month

that what i dont know how can i submit the data to monthly sheet
when i submit the data from the daily report worksheet it need to be submited in to the monthly report worksheet