Google sheets help

I am looking for someone who can help me with tasks in Google Sheets. Particularly, I need help with creating formulas. I don't have any specific deadlines and I would like to receive both a step-by-step explanation and the completed tasks. If you have experience doing such tasks in Google Sheets, please let me know. I have highlighted the specific areas I need help with. I could only add the file as a csv so it is in excel but I am using google sheets. If it doesn't match with both of the programs can you please type the formulas in and i can implement them in the google sheets document? On the Tenants tab I would like to have a "running" summary for the current leases for each of the 3 different units. Also on the schedule tab is there a way to have the data from the "tenants" tab automatically input into the schedule tab when I add a new lease to the list?