Auto populate text and add total from one sheet to another


I am trying to work on a yearly spreadsheet that has tabs for each month.
What we are trying to do is each month we update monthly tabs with names and no. of times person toileted and have another sheet auto populate the names and counts the totals of being toileted within 6 months.

EXAMPLE (Sheet 1 for July):
Name Toileted
Amy 0

EXAMPLE (Sheet 2 for August):
Name Toileted
Amy 1
In next months Bob and Amy were not toileted.

For Sheet that auto populates must update itself with BOB 3 and Amy 1 (total of Toileted added from past 6 months)

Will appreciate the help a lot!

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!