VBA to 'on open' of workbook look at all sheets for 'OVERDUE' and transfer to Main Report

Hello,

I've scoured the internet for what seems decades today, in and out of forests of code and macros that I 'sometimes get' and 'mostly don't get'. I am using Microsoft 2010 and have limited understanding of VBA.

I'm trying to do 2 simple actions. When opening the Workbook - have the workbook automatically search itself to find any field that is listed as either 'OVERDUE' or 'DUE' onto two separate report sheets.

[Edit - I need the WHOLE LINE to be copied across to either report page, once it's been listed as either overdue or due]

I'm not concerned if I have to copy a code to each individual sheet so that it transfers the data over, I just need help in understanding how to write exactly what it is that I want it to do.

My workbook has 9 sheets that I want the information to be trawled through to find, for ease of understanding at this stage, I've just unhidden two of them, the main register page, and the two sheets that I'd like the information to be transposed onto.

Is there anyone out there who can help me? (Pete_UK - you seem to have a good knack of things, but I didn't know if I was allowed to contact directly)

Kind regards
Pip

HHTS-REG-002 v2.0 Document Control Register.xls