FIND DATA WITHIN DATA (V-OR-H LOOKUP/FIND/MATCH?)

[Jaladino]

HELLO,

IN A WORKBOOK NAMED RECIPEC I ENTERED 5 SHEETS CONTAINING 5 DIFFERENT
RECIPES IN EACH SHEET. EACH SHEET CONTAINED, COLUMN A; VOLUME OF INGREDIENT,
COLUMN B NAME/DESCRIPTION OF INGREDIENT. IN THE LAST SHEET (6) I LISTED, IN
COLUMN A, ALL INGREDIENTS USED IN ALL RECIPES (SHEETS), AND IN COLUMN B I
WOULD WANT TO HAVE A FORMULA WHICH WILL RETURN HOW MUCH (SUM) OF THAT
INGREDIENT I WILL NEED BASED ON A TABLE IN SHEET 6 WHERE I CAN SELECT
(THROUGH A DROP DOWN LIST) WHICH AND/OR HOW MANY RECIPES (SHEETS) I AM DOING
..

THANKS IN ADVANCE,

JAY