Find and copy specific data from one sheet to another

I have two sheets. The first sheet contains a bunch of statuses in various columns and the second sheet will be the report output that I am looking for.

In more detail:

Column A contains unique numbers, Column L,O and R contains various statuses. What I would like in Sheet 2, I setup a Data Validation in List view a list of statuses in C1. If I select let say Status: Open I would like the formula to pull the Unique number from Column A (Sheet 1) and paste it in Column A (Sheet 2) and along with the Status from Column L, O or R and paste the status I selected in Column B (Sheet 2) The tricky part that I can't get working is having Excel look for the statuses in three different columns and have it pasted it in the second sheet. A unique number can have the same status in Column L, O and R, therefore there should be three rows in Sheet2 with the same unique number.

Is this possible?
Thank you

Hi,

Thanks for your response:

Heres an example:

Sheet 1:

Col A|L|O|R

123|OPEN|NOT SUBMIT|LATE
234|ONTIME|OPEN|OPEN|
345|LATE|OPEN|LATE
456|LATE|CANCELLED|ONTIME


Sheet 2

C1: Contains a list of statuses

Lets Say in C1: OPEN is selected

Then I would like to list the COL A Numbers along with the status OPEN: (if its possible to only list a row once when there are duplicated status eg. 234, that would be great)

Number that would be listed are
COL A|B
123|OPEN
234|OPEN
345|OPEN


Thank you!

Perfect, Thanks so much! Really appreciate your time you spent to help me out