So, essentially here is what I do:

I enter data into SHEET 1 multiple times per day ... one line example here:
Capture.JPG

Sometimes "Report Only" is replaced by "Medical Aid" or "Lost Time".

WHAT I NEED TO HAPPEN:

When I enter data into SHEET 1 that is either a MEDICAL AID or a LOST TIME, I need certain of those cells I populate in SHEET 1 to copy to SHEET 2 (=+'SHEET 1'!A1) ... problem I am having is that A1-O1 will always be changing, once A1-O1 is filled with the data, I enter the new data in A2-O2 and so on.

How do I write the formula on SHEET 2 to capture only MEDICAL AID / LOST TIME entries that are made on SHEET 1 when the referenced cell(s) keep changing?

P.S.: I would upload the sanitized workbook, but it is over 9MB and won't attach.

Thanks in advance for all your help and suggestions to come!