Most Efficient Way in Comparing Two Workbooks and Consolidating Found Differences

Hi All,

I was wondering what would be the most efficient way in comparing two workbooks, highlighting the changes, then consolidating the information into a new workbook. What I mean by changes is whether or not there were any changes made to columns B, E, or I from last months deadline list. I am not great at VBA, but I have pieced together some code below.

Please Login or Register  to view this content.

Attached are the sample files I am working with as well if it helps you get a better idea of the situation at hand.
If anyone would be able to give me some advice and/or help I would greatly appreciate it.

I apologize, the attachments are now posted.