Compiling Data into one worksheet based on a combo box selection

[kszabo]

Hello,
This is the first time I am posting. I am working on automating a report with different queries exported from Access into an existing Excel workbook. Each query is exported into a new tab with the query's name (i.e. Shipped, Received, CDR, CurrentShipped). I have a main sheet that has a combo box with a list of programs. I need to compile data from each of the sheets in the workbook based on the combo box program selection.
Is there a way to do this and would someone be able to walk me thru this process please?

Any help is greatly appreciated.

 

[kszabo]

To make it clearer. I have one tab "REPORT" that contains the combo box selection. I am looking to find the count of a specific program (which would be selected in the combo box) that were received (Received tab), shipped (Shipped tab), and Rejected (Shipped Tab), and ones that had CDR (CDR tab) within the current month, and shipped within the current month (CurrentShipped Tab). I need data to pull onto one worksheet (datadump) and correctly fill in the columns (SO_Order_NO, Description, CO_Reference_Date, Acutal_Ship_Date, Part_Status, OMC_Approved_Date, Actual_Ship_Date (from CurrentShipped Tab). I need the data to fill in to the appropriate columns. And I need this to do a total count and put it in a format I have in sheet 1 (REPORT). Any help????