I am creating a workbook and need some help.

Sheet 1 is where I enter data (qnty of products made is then broken
down into its composite parts and their qnty) eg below

CELL A1 = CASES MADE = 1

CELL A3 = CASE TYPE A = 1
CELL A4 = LABEL TYPE A = 2
CELL A5 = CASE LINER A = 1
CELL A6 = OTHER ITEM A = (NO FIGURE INPUT)

I would enter the same type of info for several products each using
the same components.

I would like to summerise the total qnty's on a seperate sheet to
print out Only those items that have a figure input next to them. to
look like the example below

HEADING = TOTAL QNTY'S USED

CASE TYPE A 100
LABEL TYPE A 25
CASE LINER A 100

One way is to use a pivot table report.
Data Pivot table report

Excel has built-in help on pivot tables.