Hi

I am only basic in Excel and do not know how to use many of the formulas, or
understand them at all....

I would like to know how I can connect worksheets.
For example.
wksheet 1
A B C D
E
PRODUCT SIZE TYPE AMOUNT NUMBER
VERITAS 20 VEG 14
68794
REDBULL 8 FRUIT 6
68799
VERITAS 18 FRUIT 12
68752

and then i want to have different worksheets (with the same table on them),
for different products, and for all the product worksheets to be connected to
my first worksheet.

When I enter a row of data into my first spreadsheet, I want the entry to
automatically be put onto it's corresponding worksheet.
So if i enter another redbull, into my table, i also want that row of
information to be shown on the 'Redbull' worksheet.

basically a worksheet displaying/summarising ALL products, and then separate
worksheets with product specific information only on them. but I dont want to
have to enter the same entry onto 2 different worksheets, I want to only
enter it into the First spreadsheet, and for it to automatically connect to
it's own specific worksheet (relating to the product name)

sorry, not very good at explaining. but hopefully it makes sense.