First time poster. I hope you could give me a hand.

I am trying to split a worksheet into several different worksheets based on information in one Column.

A basic example of what I want to do below:

I have a master worksheet that will have a list of customers, products they buy, for how much and if it has been paid yet.

All sales are entered into a master sheet and then copied using dropdowns or if statements at present.

Both of these processes are very time consuming when you need to arrange and sort for a large number of different tabs.
I want to find a way to split the first list into separate pages for each customer.

I have seen a number of forums suggesting to use coding or VBA but this is something I have not done before and am having difficulty locating on Excel 2016 as all of the old posts seem to refer to older versions of Excel so any screenshots and examples are difficult to follow.

I have attached a screen shot below of the table and how it would be separated.

Attachment 514618

Attachment 514619


If anyone could help it would be greatly appreciated.

Kind regards,
Peter