VBA: Compare 2 sheets for differences & create new sheet with differences.

I need to compare maintenance programme revisions, for an aircraft.

• 2 different revisions.
• Revision 0 has number of tasks (c. 2000)
• Revision 1 has new tasks, deleted tasks or tasks with changed due dates, times etc. (c. 2100)
• Task data in each can be spread over multiple rows.
• Aim: Compare Rev. 0 & Rev. 1 for new, deleted or revised data.
• Example: Sheet attached.

I typically use the following method (I would attach a video, but max ZIP file size is 9mb, video is 20mb).

1. Extract sheet from Maintenance System, with tasks at Revision 0.
2. Extract sheet from Maintenance System, with tasks at Revision 1.
3. Copy 1st sheet in Excel, (tasks at Revision 0) to new 3rd sheet.
4. Name 3rd sheet 'Comparison', between Revision 0 and Revision 1.
5. Copy tasks from Revision 1 into the 3rd sheet also, for side-by-side comparison
6. Use formula "=A1=B1", to compare tasks for new tasks, new due dates, etc.
7. If a new task has been added, or task deleted a number of FALSE values will appear
8. I manually cut these and paste into 4th sheet entitled 'Differences'
9. Exercise Aim 1: Identify new or deleted tasks in 'Differences' sheet.
10. Exercise Aim 2: Identify task differences in 'Comparison' sheet.

Typically, there are 2000 tasks, with c. 500 differences, cutting takes a long time. Is there a less manual method of doing this?