Helo to all experts in this forum. I am very new on this and more new in excel for the level I need for my project. I hope somene could help me on this issue.
I have in an excel document I have called (Inspection Format SHARED FORUM). In this file there are six worksheets defined as follow: (I have highlighted the sheet I need to be linked to transfer data)
Sheet 1 = Planned Inspection Form
Sheet 2 = Hazard Identified
Sheet 3 = Report
Sheet 4 = Severity
Sheet 5 = Shared
Sheet 6 = New Data Enter
I guessed I found the way to share my excel document. I have a url link but the system of this forum do not let me share the link by now.

Sheet 5 (Shared) I have three basic columns all over the sheet.
Columns A, B and C.
Column A contains the CODES
Column B the Description of each code and
Column C the scale or value defined for each code selected during the inspection.
The Scale or Value is selected from a list from "0, 1 and N/A) where:
0 = Unacceptable (Means, it needs an action taken)
1 = Satisfactory
N/A = Not Applicable

Any CODE/Description that get scale selection = 0 need an action taken that would be added in the Sheet 2 (Hazard Identified)

Sheet 2 (Hazard Identified) I want to focus just in column A and B:
Column A = "CODE" Here, Starting in Cell A15 I would like that any Code from Sheet 5 (Shared) that get a selection value =0 automatically be transferred to Sheet 2 (starting in Cell A15). So, if in Sheet 5 (Shared) were selected 10 codes = 0 then each code selected =0 be transferred to sheet 5 (Shared) as separate code starting in cell A15 and so on (A15, A16, A17 ...). The same with Column B in sheet 2 (Hazard Identified)
Column B = Deficiencies/Hazard Identified. Here, any Description in Sheet 5 associated with the CODES that got a selection value = 0 automatically be transferred to sheet 2 in the column called Deficiencies/Hazard Identified starting in the cell B15. and so on (B15, B16, B17 ...).

My expected result is that any code and description that get a value = o in sheet 5 (Shared) be transferred automatically to sheet 2 (Hazard Assessment). In other words, I just need in sheet 2 all the codes that got value = o which are the ones that need an action taken to follow. If all codes get value = 1 or N/A then nothing will appear in Sheet 2 because Value = 1 means all elements inspectors are satisfactory and do not need any action taken.

I hope to have explained myself well and to have made the process of sharing the sheet well also because this technology is a bit complicated but fascinating.
Thanks in advance to whom will be helping me to solve this project.