Creating a Summary Page of Selected Data Lines from multiple worksheets in same workbook

Good afternoon.

This is such a great site with a wealth of information.

I always considered myself a fairly good excel user, until stopping by here Now I realize I haven't even scrapped the tip of the iceberg.

Here's what I'm up against:

I have multiple sheets on an order form type of file, that I want to pull only the selected quantities and place them on a "Summary" page of sorts. This data is inputted with a number 1-infinity.

Seemed pretty easy when I took the task on, but I just am drawing a blank now from a coding perspective.

I've attached the worksheet so you can see. I'd like to ignore "PO info" and "Order Total" tabs.

Thanks so much for any input here.

Regards,
David