Select data in Sheet 2 based on column values in Sheet 1

Hi all,
I have a requirement where in i have two sheets. In a column of the first sheet are unique document numbers. In the second sheet, I have around 8000 rows, of which document number is a column, but the document number has multiple rows based on values in other columns. I need to filter out rows for the document numbers in my second sheet for all values of the document numbers present in the column in the first sheet.How can we achieve that ?

Any help would be highly appreciated

Welcome to the forum.

Unfortunately, your first post does not comply with rules of the forum and, consequently, is unlikely to get a response. Please change the name of the thread to something specific.

While you're doing that, you might find more people willing to look at the problem if you post a sample workbook.

Regards