Need help to merge multiple data sets and sum certain columns subject to other fields meeting criteria

I have a years worth of monthly submitted data (12 files total, individual files are large) and I want to aggregate rows subject to columns matching, summing one column. So if I had column a, b, c, d...