Automatic add lines from differend tabs to 1 tab

[Shivex]

I work in a bar and we need to do stock take every now and then.
i have differend tabs for different catagorie's of drinks; soda's, whiskey, rum, gin, etc. that has different colums as; Product name, Price per bottle, Value of total counted stock EX Tax, Inc Tax etc.
now on Tab1 i would like to have a list of al the product names from the different tabs, but so that when i add or remove a product from one of the Catagorie tabs it also add/remove's it from my counting tab (Tab1).

and the posibility to hit ENTER in on of my catagorie tabs that it adds a new line with the formula's that is used in the line above it.

 

[Rijnsent]

Hi Shivex,
with VBA that would be possible. You'd need to have a macro in every sheet that does that with the Worksheet_Change(ByVal Target As Range) event. If you're new to VBA, these are some good courses to get you started: Excel-Pratique EN and Excel VBA Programming - a free course for complete beginners
An alternative would be to set up your data in the sheets in Tables (in excel menu: Insert->Table) and use formulas on the first page to pull the data in, but that might be a dash complicated to set up.
Cheers,
Koen