How to display information as a list reffering the column in Sheets?

Hi there,

We have a database of proposals. User access to proposals by the password.

Password=REFERENCE COLUMN in Google Sheet

I need to display all the rows that fit the REFERENCE COLUMN. It can be 2 or 100 rows.

But if to display info - only the first row is displayed.

Because of this, I can't display data in a table like here.

Is there any possibility of using Landbot or Zapier for example?

Thank you