Update multiple cells in same column from sheet 1 to sheet 2

Can Some one help me

I wanted to automatically update data from sheet 1 to sheet2 based on some criteria. So I used array formulae

=IFERROR(INDEX(Sheet1!B$2:B$500,SMALL(IF(Sheet1!$A$2:$A$500="3rd Party",ROW(Sheet1!$A$2:$A$500)-ROW(Sheet1!$A$2)+1),ROWS(A$2:A2))),"")

Now I am trying to update data in a new sheet3 from sheet1, which updates data named Apple and Sony from Column B in sheet 1 to sheet 3. I tried to use OR condition but got no output.

Thank you in advance.

Try this Array Formula. (Requires CSE)
On Sheet3
In A2

Please Login or Register  to view this content.

and copy across and down.

Is this what you are trying to achieve?

Yes that cleared a part of my doubt. Sorry I was not clear in question. In the below attached workbook, In sheet 2 I want to automatically update columns for only 3rd party applications and also there re-check status should be either open or "blanks" (so, I want to eliminate the closed re-check status rows for 3rd party).

I tried to change the above formula like
=IFERROR(INDEX(Sheet1!B$2:B$50,SMALL(IF((Sheet1!$A$2:$A$50="3rd Party")+(Sheet1!$G$2:$G$50="Open"),ROW(Sheet1!$B$2:$B$50)-ROW(Sheet1!$B$2)+1),ROWS(A$2:A2))),"")

Hope I am clear this time.

See the attached sheet.