Skip Rows That Don't Match in Linked Workbooks

[CuriousForge]

I have 2 workbooks Linked: Table 1 (Workbook 1) & Table 2 (Workbook 2).

"Declined" items of Table 1 are to be listed in Table 2 (two different, but linked workbooks). So 'Declined' from Table 1 is the main judgement criteria.

1. Formula - Green cell in Table 2 -

IF D2 of Table 1 is "Declined" then it fills up the rest of the criterias (Table 2 A2,B2,C2 from Table 1 as referenced

Hence, other cells of Table 2 take D2 of Table 2 itself as reference.

2. Problem - If Table 1 has "Approved" then it leaves the cells of Table 2 blank - the whole row as a result. I want to skip "Approved" rows completely (i.e blanks) so it moves to the next entry to check for the criteria & fills only "Declined" as a result in Table 2.

Anyone with a VBA/Formula to help with this?