I have a work book with 6 work sheets. worksheet 1,2,3 are customer names (lib1, lib2, lib3). Worksheets 4,5,6 are material types (OrdersP, OrdersV, OrdersG).

When an order is filled in on one of the OrdersX worksheets, I would like the Customer worksheets to automatically populate with that customers order. This would be based on Column A - Customer Name.

Thank you for this help.

I have attached my workbook for reference.Test_Book2.xlsx