Extracting product information from main list to individual product tab

[funcppl5]

Hello all,

I was hoping to get some help. I have a workbook with the first tab being the Master Table: this being as I get product in I input it to this table only. On the remaining tabs I have the individual products.

What I am trying to figure out is when I get a new item (say "D" batteries) and input it and its information into the Master Table. I would like that information to then go to the "D" Batteries tab. I would also need it to go to the next available line on that tab.

I would appreciate any help you can give,

Thanks
Shawn W.