Need help to write Macro code to calculate DPU with respect to associate in monthly basis

Hello Experts, need your help to solve below issue.
I have Work done by associates on every month and the total errors on each work item.
I need to calculate DPU of every associate in monthly basis and plot the same in one table.

I have attached the sample excel,
to clarify few for an example: In sheet "Jan" There is a drawing # in Row 4, and blank from row 5 to 10, this mean Errors in column "I" is related to same part number done by associate "1".

Now i need to calculate.
Step 1: Count howmany drawings (Coulmn E) Associate 1 did in month Jan
Step 2: Sum total errors (Column I) by Associate 1
Step 3: Calculate DPU which is fraction of Total Errors / Total drawings.
Step 4: Populate a table in sheet "DPU" to show associates in rows and month in columns (Plot DPU with respect to Associate and month)

Note:
Though i have mentioned only three months, we will be populating the data for whole year.

Thanks
Arun

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)Sorry for off-topic interjection:

Although there is no official rule regarding this behavior, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

Thanks again for all your hard work here!