Hello,
You may try to use sumif. I have included a column in sheets one, two and three indicating which month the payment belongs to (using MONTH formula). Then writing a SUMIF formula once should solve all your problems
You may check the attached excel.