Creating a list from a larger array

This is hard to explain...

I have a sheet with a lot of information for various suppliers.
I can filter this list to 1 supplier and look at just their information.

I want to be able to "vlookup" so to speak, the entire sheet and create a list on another worksheet with the information from only 1 supplier.(as if I had filtered it)

This is to enable me to report on 1 supplier and print out the data.
I want to do this by putting their code in a reference cell so it than gathers the information with the matching code (like the vlookup does) but lists it 1 item after the other with only the information from the selected supplier.

Please help

This can be done several ways. Do you have a copy of your data that we can see to help fit it to your needs?

I do.

I need to take the information in 'blue' on sheet1, and re lest it on sheet2 sorted by one of the numbers in 'orange". eg 5020 is a good example.

I hope this is clear enough. Thank you for your assistance.

Is anyone able to solve this one ?
I have been plugging away with no joy.