Multiple Worksheets - Need data from one sheet to be populated in other sheets

[tb5536]

Im not sure how to ask this question, so I will tell you what I have.

I have 4 worksheets.

The first 3 sheets have the same column names (Columns A -D):
Table / System / Subject / Entity

Sheet 4 has these columns (Columns A - D):

System / Subject / Entity / Table

Here is what I need to do:

For example:
Sheet 4 Cell D4 has a value of ITEM (Column D in Sheet 4 is Table).
Sheet 1 (Column A is Table) if ITEM is listed as a value in Sheet 1 then I need the System/Subject/Entity from Sheet 4 to be populated in Sheet 1.

I hope my question made sense.

Any help would be appreciated.

Thanks!!