Need help and advice

Problem: I have a pivot table that is getting data from an external database (Access), which I update this database monthly. What I would like to do � if possible, is to have the job code totals from the pivot table, automatically populate the Job Code total column in Sheet1. The condition would be:� if Job Codes from pivot table1 equals Job Codes in Sheet 1, and Month equals to �March� or current month, then add totals.� I would like to have this macro perform when month changes.

See attached file...please