I have an inventory workbook with 5 worksheets inside; One of the sheets is a master listing all inventory items. The others are dedicated to type of inventory items i.e. publications/images;
I need to set it up so that any new data entered into the new separate sheets is automatically entered into the master sheet,
Can anyone advise how I might set this up.
Thanks in advance
Dave
Related:
Data entered in one sheet automatically appearing in a master sheet