Excel- pull out ID + Info of my customers (bulk)

Perhaps sort your range by Customer ID
Select the entire range - Data - Sort - Sort by :ID

Make a table to add the costumer.

F2=IFERROR(IF(MATCH($A2,$H$2:$H$10,0)>0,"yes",""),"") and drag down.

After that filter on "yes" in column F.

See the attached file.

An easy way would be to use Power Query (as you are using Excel 2016, you have it already installed)
two queries with your table and a table with the list of required IDs (both as connection-only) and then Wuery to merge these two as Left-joint (only records from the selected IDs list). And that's it (well, sorting shall be added to this last query)

So add next ID like 123 to cell G5 (expanding table with selected IDs) and rightclick on output (green) table and select Refresh Query to see how it works.

The great news - it will be pretty quick for large datasets too.

@Pepe Le Mokko

The attached was an example..... - the spreadsheet I use has more than 12K rows......if I use the filters each time takes 20 minutes just for filtering

@oeldere

I cannot amend or use the filters in the main data spreadsheet as this has more than 12k Rows....i need something in another sheet to find more than one customer ID and all their orders.

I will try on Monday - I've the spreadsheet on my working computer, I will test your suggestion and let you know if helps Thanks

Originally Posted by Alessio277

The attached was an example..... - the spreadsheet I use has more than 12K rows......if I use the filters each time takes 20 minutes just for filtering

Then in the future please inform us, so that we avoid wasting time . thx