VBA to consolidate data based on criteria from several workbooks and sheets

Hi everyone,

I am VERY new to VBA and need some assistance please.

I am trying to consolidate data from multiple workbooks and multiple sheets based on certain criteria. What I need to do for example is if an employee listed within one workbook is a cook and his time was charged to a client for a specific day I need to get a total of all of those days based on the employee title and if they received a day rate (DRL) for that day, but I need to make sure that it is only counting the work order number one time per day, so if the employee had a bonus associated with the same work order number on that same day I need it not to be included in the total, however if they worked under 2 different work order numbers the same day I need it to count that day twice? Is this possible? Also the dates each employee has listed on their timesheet may not be listed on the same row as the next employee, and I need it for three different titles. Attached is an example.

Hi CWiley,

Welcome to the Forum!

The sheet you posted is password protected.

But you mentioned that there would be several books???