need to copy some cells contents to a another worksheet based on a value condition

[Mochmoch]

Hi,

I am not really good in writing macro codes and I need some help.

I have an check list where i need to check if each row meets the standards. so if yes, I just tick the checked box. if not I need to enter X (for automatic calculation) under the "OK"cell.

what I need is that where I have a cell with Value X in a specific cell range, I need excel to copy cells' content of the same row to another sheet. for example 1 st row to be copied should be pasted in WS "AP" cell: B3 then the second one should go to the next empty row in AP worksheet. Also I need the macro to tell me from which worksheet this row has been copied and create a hyperlink to the relevent worksheet.

please check the attached workbook and many thanks in advance for your help

Best
Mochmoch