Function to move value from cell to cell based on matches

Hi
Hope you can help with this one, it is getting to advanced for me with the dependencies.

Basically I have two sheets, 1 with items, and one with an overview of the status of each item.

I'll do my best to explain
1. The values from Page1!A should copied to Page2!A
2. But only if the value from same row in Page1!F matches Option1.
3. If Page1 has multiple items in a row in colums, H,I,J,K etc the value from same row column A should be copied to each item in page2.

Example:
Page1!A9 is 33333
Page1!F9 is Option1 (instead of Option2) Page1!A9
Page1!H9 and Page1!I9 matches Page2!C4 and Page2!C6
Beause of these matches, Page1!A9 is copied to Page2!A4 and Page!A6.

If Page1!F9 is changed to Option2 the values should be removed from Page2!A4 and Page!A6.

There can be multiple matches between cells in Page1!H,I,J,K etc and items in Page2, but there cannot be a match where Page1!F of the same row both have Option2. Basically each item can only have one "kode".

This is to keep track of where the items on Page2 are.

I hope the question is clear enough.

Thank you :-)
And thank you for pushing me in the right direction

Thank you - yes copied or mirrored to would be a more correct term than moved.

I copy-pasted the formula, but it is not accepted as a formula, it just comes in as text in the cell and no result or error.
I've checked the format of the cell and that is set to Category General, and if I edit the cell, and put in a simple formula, it calculates it fine "=SUM(1+1)" for example

Worked like a charm - I'll get in into my non-anonymous sheet right away to test it to full extent

Much appreciated