Trying To Pull Multiple Records From The Same Database With Similar Criteria

I am working on an excel project for work and am having trouble with one formula. I am trying to pull records based on customer ID #'s from one sheet and have them automatically populate on another sheet. Here is an example of something similar to what I am working with. Any help would be greatly appreciated! Thanks!

1st Sheet
Customer ID Name Sales Rep Volume $$ Total
5568752 Widgets, INC Joe Smith 22000 180523


2nd Sheet

Customer ID Product Price
5568752 Widgets 5
5568752 Blue 22
1115555 Paper 34
2457865 Cardboard 9
5568752 HP 18
3652548 Calculator 47
2142545 Octopus 63
5568752 Phone 3.15

anyone have any suggestions?