Hello

I have a workbook with 6 worksheets and a master worksheet.

The 6 worksheets contain product codes, description, sell price and other discount prices.

The master sheet contains the three columns for product codes, description and sell price of all the items on the 6 worksheets, this master sheet is connected to a discount form which in using data validation and Vlookup populates columns. This all works ok..

What I want to happen now is that on any of the 6 worksheets, If I enter a new product, wherever in the list, it automatically populates the master sheet with its code, description and sell price in the same position on the master as it was entered on the worksheet.

Not sure it this can be done with formula, macro etc
Hope this make sense.